You’re offline. This is a read only version of the page.
Announcements
Hello everyone ! I'm proud to be posting here and being part of this beautiful community!
I have a big problem understanding a flow:
1 - I have an excel which contains 9 tables;
2 - I will generate a recurring flow every 1 day of the week for several people, that is, each one of them will receive the content of the row of each separate table;
3 - This table belongs to our sales team, but in the excel file the column is formatted as a currency;
4 - The email is sent to the seller with the content I selected from this table, but the format of the numbers only comes as an integer.
What do I need to do to appear as currency in the generated HTML V2 email as well?
This is the table that contains the values.
This is the flow:
Flow occurs normally. But this is the result:
Please, it would be very important for someone to provide me with a solution to get around this little detail.
I am very grateful. Pedro Henrique.
I'm not sure if this the answer you are looking for, but you can convert the number string to a floating point number, then format it as a currency to your local region.
This is my demo Excel file:
In row 2, the currency value is stored as a string in Excel it seems, and Power Automate receives the value as string "232":
The formatNumber function is used to transform the value string "232" to R$232.00:
This is email that was sent to Alex Wilber:
This is the email that was received by Alex Wilber:
If you don't want to use expressions there is the Format Number action which you could use:
See the documentation for more information: Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs
Ellis
Share
Report
All responses (
Answers (
11,735
