web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Format excel table cur...
Power Automate
Unanswered

Format excel table currency using html email

(0) ShareShare
ReportReport
Posted on by

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?

PedroBrazil_1-1630534207571.png

This is the table that contains the values.

 

This is the flow:

PedroBrazil_0-1630534148337.png

PedroBrazil_2-1630534333614.png

Flow occurs normally. But this is the result:

 

PedroBrazil_3-1630534432094.png

 

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.

 

Categories:
I have the same question (0)
  • Ellis Karim Profile Picture
    11,735 Super User 2025 Season 2 on at

    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.

    ekarim2020_0-1630787838098.png

    This is my demo Excel file:

    ekarim2020_1-1630788367081.png

    In row 2, the currency value is stored as a string in Excel it seems, and Power Automate receives the value as string "232":

    ekarim2020_3-1630788819776.png

    The formatNumber function is used to transform the value string "232" to R$232.00:

    ekarim2020_5-1630789632783.png

    This is email that was sent to Alex Wilber:

    ekarim2020_4-1630788977492.png

    This is the email that was received by Alex Wilber:

    ekarim2020_7-1630789993843.png

    If you don't want to use expressions there is the Format Number action which you could use:

    ekarim2020_9-1630790287983.png

    See the documentation for more information: Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

    Ellis

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

#3
trice602 Profile Picture

trice602 185 Super User 2025 Season 2

Last 30 days Overall leaderboard