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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to send currency f...
Power Automate
Answered

How to send currency format in email from excel.

(0) ShareShare
ReportReport
Posted on by 31

I have a flow that reads a key value pair out of an excel spreadsheet, and in the spreadsheet my value is a currency field.

 

When I run "Get a Row" from excel, and pull that data, it's pulling it in as a string (I think).  So, a field of $25.00 in excel is pulling in as simply 25.

 

I've tried a Compose function, and convert it to a float(), and various things that never seem to make any difference.

 

Screenshot from 2021-09-07 14-42-57.png

 

Is there any way to convert this into USD currency in the format $1,000?

Categories:
I have the same question (0)
  • Verified answer
    ScottShearer Profile Picture
    25,290 Most Valuable Professional on at

    @slimmons 

    Try using the formatNumber() expression.  

    These two links should help:

    Documentation

    Standard format strings

     

     

  • slimmons Profile Picture
    31 on at

    I actually did try formatNumber(), but I hadn't tried it after converting it to a float using Compose.  The following solved my issue, thanks for the help.

    Screenshot from 2021-09-07 14-56-34.png

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard