Unanswered

How to send currency format in email from excel.

(0) Share

Report

Posted on by slimmons

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:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@slimmons

Try using the formatNumber() expression.

These two links should help:

Documentation

Standard format strings

Was this reply helpful? Yes No
slimmons 31 on at

Like (0)

Report

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.

Was this reply helpful? Yes No