Answered

FormatNumber issues in a flow

(0) Share

Report

Posted on by SaltySeaDog

I have two cells in the same row in a HTML table within a flow, which takes data from a SharePoint list. Both numbers in the list are formatted as currency in the list, the first one is just a number, and the second is a calculated field.

I formatted the first number in the flow, and it worked fine, but when I tried to format the second number the flow keeps failing.

If I do not use any formatting of the second number, the flow works fine, but the cell out put has around 10 decimal places.

Is there an issue with formatting calculated fields in Power Apps? If so, is there a work around? Many thanks!

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (2)

v-jefferni on at

Like (0)

Report

Hi @SaltySeaDog ,

Could you please share screenshots of your flow in edit mode?

Best regards,

Was this reply helpful? Yes No
SaltySeaDog 37 on at

Like (0)

Report

Hi,
Please see the flow below, note that I move the calculated column to its own row to see if that would work, it didn't. I also changed the calculated column to a number by using the VALUE function in my SharePoint list but that didn't work either. FYI the Yes side of the Condition works fine.
I am pretty new at this, and it you can help it would be much appreciated, as this is giving me a sore head.
Thanks

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @SaltySeaDog,

Can you share your formatnumber expression?

As far as I am aware calculated numbers are returned as strings. Which means you would first have to convert the string (text) to float (decimal) before you use a formatnumber function on it.

Below is an example which converts it to decimal and uses the C2 format to convert it to a currency with two decimals.

formatnumber(float(triggerOutputs()?['body/Cost']), 'C2', 'en-gb')

Was this reply helpful? Yes No
SaltySeaDog 37 on at

Like (0)

Report

Hi,
Here is the expression:
formatNumber(items('Apply_Info_to_Each_TMDetailsHTML')?['TMLabour'],'C2')

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @SaltySeaDog,

In that case have you tried the below instead?

formatNumber(float(items('Apply_Info_to_Each_TMDetailsHTML')?['TMLabour']),'C2')

Was this reply helpful? Yes No
Verified answer

SaltySeaDog 37 on at

Like (0)

Report

Hi,
I applied
formatNumber(float(items('Apply_Info_to_Each_TMDetailsHTML')?['TMLabour']),'C2') and it worked.
Thanks, it was driving me crazy.

Was this reply helpful? Yes No
CallistusL 10 on at

Like (0)

Report
From a SharePoint list and currency field:
formatNumber(items('For_each')?['Cost'],'C2') - doesn't work
formatNumber(float(items('For_each')?['Cost']),'C2') - doesn't work
formatNumber(int(items('For_each')?['Cost']),'C2') - doesn't work
and because there is no versioning in Power Automate I can't go back to what worked previously to figure out what was different!
😠

Was this reply helpful? Yes No