cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MStark17
Helper I
Helper I

Select Function with Number Formatting

I'm sure this is a simple thing to do but I'm not sure how to do it. How can I format one of the keys from the select function to output a currency number format? I've attached my flow and output as reference.

 

Screenshot 2021-11-16 170427.pngScreenshot 2021-11-16 170509.png

 

How can I format the Amount column so numbers would instead look like $105,087.69?

1 ACCEPTED SOLUTION

Accepted Solutions
ekarim2020
Super User
Super User

You can use the formatNumber() function.

Example: formatNumber(17.35, 'C2') returns $17.35.

 

In the Select action add the formatNumber as an expressions:

2021-11-17_17-42-04.png


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

 

 

View solution in original post

2 REPLIES 2
ekarim2020
Super User
Super User

You can use the formatNumber() function.

Example: formatNumber(17.35, 'C2') returns $17.35.

 

In the Select action add the formatNumber as an expressions:

2021-11-17_17-42-04.png


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

 

 

Worked great, thanks!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,903)