I am using a calculated number in a SharePoint list and using this value in an email using a Power Automate Flow. The value should come as an integer.
When the value is passed through to Flow, it's converted to a string with a decimal point and 14 zero's added, For example, if the value is 3, then it comes as 3.00000000000000.
How can I format this to an integer from decimal in Flow?
I tried the below expression to format this,
formatNumber(int(outputs('When_an_item_is_created')?['body/TotalDays']), '0,0', 'en-us')
Where my flow is triggering with SharePoint action is 'When an item is created' and SharePoint calculated column is 'TotalDays'.
After applying this formula I got an error like:
"Correct to include a valid reference to 'When_an_item_is_created' for the input parameter(s) of action 'Send_an_email_to_user_for_successfully_submitted'."