Unanswered

Followed youtube, it worked, but no currency format

(0) Share

Report

Posted on by CU12112144-0

Hello - I have followed https://www.youtube.com/watch?v=1g7NA5hYYSo and my flow works to remind me of upcoming payments based off ReminderDate, but the amount in the email body does not format as a currency. I have tried so many different options, but each step I try to add, the flow then fails. How do I format the amount as a currency in the email chain?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Mark Nanneman 991 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Have you tried the formatNumber expression or the "Format number" action?

Example:

You can also use the built in "format number" action:

If you need to convert an array of numbers, you can do that with an expression in an select action

If you've tried these options can you post a screenshot of your flow and the error you're getting?

Was this reply helpful? Yes No
CU12112144-0 2 on at

Like (1)

Report
Copy link

Link copied!

That did not work, but I finally ended up sharing the entire code of all the steps on ChatGPT and the following worked:

formatNumber(float(item()?['TotalAmount']), 'C', 'en-US')

Was this reply helpful? Yes No
Mark Nanneman 991 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Ah, okay it sounds like your number was probably in string format, makes sense if you extracted it from an email.

Was this reply helpful? Yes No