Unanswered

Format Currency in HTML Table

(0) Share

Report

Posted on by Barber_Chris

Hi,

I have a flow that creates a HTML table from a sharepoint list then adds it to an email. The flow works fine and all the data is there but the currency colums display such as 30.0000000000000 with no £ sign.

Can anyone advise me how this would be achieved.

Regards,

Chris

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (0)

Barber_Chris 99 on at

Like (0)

Report

I forgot to mention im looking to reduce the number of decimal places to 2

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Barber_Chris

You can initialise a variable and then pass the currency value in that and then use an expression to trim the decimals. Please see the solved thread below for the expression:

https://powerusers.microsoft.com/t5/Building-Flows/decimal-place/td-p/50303

Rounding currency/ decimals is not available as direct action or function in flow currenlty and you can upvote this idea here:

https://powerusers.microsoft.com/t5/Flow-Ideas/Currency-and-decimal-format-in-Microsoft-Flows/idi-p/38723

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report
Hi @Barber_Chris ,

I assume that the column CIS is a calculated column, I have figured out the following workaround for your scenario, please check it for a reference.

Input the following code in the value field of CIS field:

concat(string(float(item()?['cis'])),'£')

Best regards,

Mabel

Was this reply helpful? Yes No
Barber_Chris 99 on at

Like (0)

Report

Hi Mabel,
Im getting somewhere following your post thanks.

So I tried as you said with the following expression:-

concat(string(float(item()?['CIS_x0020_on_x0020_Labour'])),'£')

And not its displaying like this...

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report

Hi @Barber_Chris ,

What’s your expected result? Could you show me an example?

Actually, I am getting the same result with you for the CIS column.

However, Flow doesn’t have the same Text function to format a number or a date/time value.

Let me see if I could help figure out it for your scenario.

Best regards,

Mabel

Was this reply helpful? Yes No
Barber_Chris 99 on at

Like (0)

Report

Hi @v-yamao-msft
Thanks for ocming back to me so in looking for it to display like this £1000.00

Regards,
Chris

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report
Hi @Barber_Chris ,

Please try with the following code:

if(contains(item()?['cis'],'.00'),concat(string(float(item()?['cis'])),'.00£'),concat(string(float(item()?['cis'])),'£'))

Best regards,

Mabel

Was this reply helpful? Yes No
Barber_Chris 99 on at

Like (0)

Report

Hi @v-yamao-msft ,
Im getting the same outcome. The £ sign is at the end of the number and its not always 2 decimal places.

Was this reply helpful? Yes No
v-yamao-msft on at

Like (0)

Report
Hi @Barber_Chris ,

You may need to modify the function likes below:

if(contains(item()?['cis'],'.00'),concat('£',string(float(item()?['cis'])),'.00'),concat('£',string(float(item()?['cis'])))

However, if you want the end of the number always to be 2, you may need to add more conditions in the flow to check if it has two decimals, if not, format it.

Best regards,

Mabel

Was this reply helpful? Yes No
huntjk 2 on at

Like (0)

Report

I am using the formula posted in a solution as follows:

if(contains(item()?['NAME of FIELD'],'.00'),concat('$',string(float(item()?['NAME of FIELD'])),'.00'),concat('$',string(float(item()?['NAME of FIELD']))))

I would like for it to include 2 decimal places (the original spreadsheet has these in currency form) ---reading:

$24.00
not $24

Is there a small tweek in the code??

Was this reply helpful? Yes No