Hi everyone!
I am creating an email flow within Power Automate, I have the following action:
The email does as expected; however the line "Projected Total" returns the following:
Instead of the value being 489500.000000000, I would like it to read in a currency format (i.e., $489,500). The data source it is pulling from is dynamic and formatted properly and is an SP List. I do not want to define a value using formatnumber(.....)
How can I get the email action to send the value in a $XXX,XXX.00 format? or $X,XXX.00/$XXX.00 etc??
