Formatting Numbers

(0) Share

Report

Posted on by Andrew_J

1,962 Moderator

Hi all,

A flow that was working with the below compose action:

formatNumber(int(outputs('Get_item')?['body/Invoice_Amount']), '0,0.00', 'en-gb')

Now seems to have failed. The flow is still running and I need to correct the above if necessary then run a new test to complete it.

I know you can read this but basically take the raw out from a calculation, format to thousands and two decimal places.

Regards,

Andrew

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Expiscornovus 33,876 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Andrew_J,

The expression itself looks ok. Maybe you have a list item which has an empty Invoice_Amount field?

If so, can you try this expression instead:

if(empty(outputs('Get_item')?['body/Invoice_Amount']), 'Field is empty', formatnumber(int(outputs('Get_item')?['body/Invoice_Amount']), '0,0.00', 'en-gb'))

Btw, can you also check the outputs of the failed flow run of the Get Item action and share this with us? This could also help with troubleshooting.

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus

The data you need is as follows:
The column should never have any blank data in it. but the start of the flow is as follows:

Maybe I need to introduce a delay somewhere so it has a chance to catch up with itself. Then update the list with the values from the compose.

Regards,

Andrew

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

Like (0)

Report
Copy link

Link copied!

Hi @Andrew_J,

Thanks for sharing those screenshots.

Can you expand the Get Item action in your second screenshot and have a look in the Outputs section?

Try and find the Invoice_Amount column like in the example below. And if it is available, check what the value is in that column and share that screenshot over here.

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus

As requested:

The green I think is my input value, the blue is calculated. I do not want to be entering this data in manually. The main reason for the using the expression at the start of this thread is to make sure it looks right when input this into the word template, create a PDF and then the send for signiture.

Regards,

Andrew

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus

the list date fields

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,876 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Andrew_J,

I see your value is a decimal and not a whole number. Try using a float instead of an int in your expression.

Try something like below:

formatnumber(float(outputs('Get_item')?['body/Invoice_Amount']), '0,0.00', 'en-gb')

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus

That worked a treat, its always the small things that catch us out who are only dabbling in this from time to time.

Have a good weekend.

Andrew

Was this reply helpful? Yes No