Answered

Formatting an amount to show in a currency format (i.e. $0.00)

(0) Share

Report

Posted on by tiffany

Currently the amount from the spreadsheet is displayed in currency format. I think I need to initialize a variable and re-format that but when I tried to do that is says it needs to be outside of the loop? I'm new to this so any help would be appreciated!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

RobElliott 10,428 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@tiffany initialize a string variable immediately after the Recurrence trigger. Then in the apply to each control you can add an append to string variable and then a compose to format the value in the string variable. Then use the output of that later in your email. But one thing you need to watch is that it looks like you are sending an email to everyone in the spreadsheet for each item every time the flow triggers - unless of course you are using a filter query.

Rob
Los Gallardos

Was this reply helpful? Yes No
tiffany 30 on at

Like (0)

Report
Copy link

Link copied!

So I'm tracking up until the compose. I've added the initialize variable and added the Append to String Variable. Do you know the expression I would use for the COmpose?

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

Please note there is an action block recently released to help with currency conversion.

https://flow.microsoft.com/es-es/blog/simplified-number-formatting/

Hope this helps

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi @tiffany ,

As @efialttes suggested, you could take a try with the Format Number action, and you could refer to screenshot below to create the flow:

Was this reply helpful? Yes No
martinav 3,340 on at

Like (1)

Report
Copy link

Link copied!

This is an expensive method if you have a large dataset. Any expression that can be written to do this?

Was this reply helpful? Yes No
Aarnav 59 on at

Like (1)

Report
Copy link

Link copied!
I used this expression to format a float to currency with 0 decimal places. To have desired numbers after decimal replace 0 with a number e.g. C2 will give 2 numbers after decimal $4.00

formatNumber(items('Apply_to_each_2')?['Total'],'C0','en-AU')

Was this reply helpful? Yes No