Format excel table currency using html email

[PedroBrazil]

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.

[ekarim2020]

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