I am using a calculated column (currency) in a SharePoint list, and putting the value into an email using a Power Automate Flow. The value will always be a dollar amount.
When the value is passed through to Flow, it's converted to a string with a decimal point and several zero's added, so $5,416.52 (in SharePoint) becomes 5416.52000000000 in the Power Automate E-mail.
I have been able to use the below line to resolve my integer problem for non-currency fields.
formatNumber(int(outputs('')?['body/']), '0', 'en-us')
Now I'm trying to do the same thing as above but with Currency. Any assistance would be greatly appreciated! I have multiple calculated currency fields in the SharePoint list that I need to copy over. So an Expression would be the best route forward.
Thanks for your assistance!