Format currency

[Frankie70]

Hi all,

I am stuck with a problem.

I have a HTML Table in my flow with 2 fields with a number.

When sending this table via mail, some users get numbers without any comma (example: 123470) and sometimes the last digit is missing, because its 0.

I would like the format to be like (example: 1,234.70 EUR).

But when I try to format the number with an expression it only offers me "List of items" or "value".

This is where I am stuck.

How can I format the Price and the Sum so that they are always formatted correctly in the mail?

Any help is appreciated.

[tom_riha · Accepted solution]

Hello @Frankie70 ,

you can add the dynamic content even if it's not displayed in the list, just type in the value:

item()?['ColumnInternalName']

e.g.
formatNumber(item()?['Price'],...)

[Frankie70]

Hi @tom_riha 

on my desktop PC everything works fine. But using that flow from my mobile phone it gives me strange value because there thousand separator it’s not in the right place.

 Any idea, what is going wrong here?

 

[tom_riha]

Hello @Frankie70 ,

can you be more specific what's wrong? From the screenshots you shared it looks as I'd expect.

[Frankie70]

Hi @tom_riha 

The numbers come from SharePoint. The laptop should be 1,472.01 EUR and the mobile Phone 588.19 EUR. In SharePoint the prices are correct.

[tom_riha]

Hello @Frankie70 ,

if the same flow works differently if you start it from a different device then there might be some bug and I'd contact Microsoft. It's a cloud flow, not device flow, the device triggering it shouldn't matter.