Answered

How to format list item number as currency?

(0) Share

Report

Posted on by Rbovenkamp

I want to transform the listitems Stukprijs en AanschafTotaal to a currency number for example € 12,98

I thought this can be done by placing the fields Stukprijs a formatnumber expression, but I cannot select Stukprijs to the formatnumber expression.

Any ideas?

Aantekening 2020-03-11 170858.png

Categories:

Building flows

I have the same question (0)

All responses (16)

Answers (2)

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi!

There is a new action block to simplify format currency...

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

... but your flow is based on a 'Get items' output right? Not 100% sure, anyway, your topic should be a good reason for me to start learning Dutch 😅

If my assumption is right, and this new action block is a valid workaround, then you will probably need to use an Apply to Each to iterate all over the items. Or, use a expression based on its equivalent WDL function in your Select mapping table

Hope this helps

Was this reply helpful? Yes No
Verified answer

Pstork1 69,125 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
You should be able to use something like this

formatNumber(variables('TargetNumber'),'$#.00')

Just substitute your dynamic content and the appropriate currency symbol

Was this reply helpful? Yes No
Rbovenkamp 28 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately

Was this reply helpful? Yes No
Rbovenkamp 28 on at

Like (0)

Report
Copy link

Link copied!

Yes it's based on a get items output. But isn't there a way to transform the data in the select block directly with an expression?

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

Like (0)

Report
Copy link

Link copied!
Oops!

The error you just shared is because of using a variable in your expression that does not exist called 'Stukprijs'.

Following @Pstork1 recommendation, I would use instead

formatNumber(item('Stukprijs'),'$#.00')

If this also fails, please hover the mouse over the first SP dynamic content you assigned at the beginning to your Select 'price' column, and share the screenshot so we can identify the Stukprijs internal name in your Sharepoint list ... since sometimes the SP column internal name does not match with the one shown by the Flow User Interface

Thanx!

Was this reply helpful? Yes No
Rbovenkamp 28 on at

Like (0)

Report
Copy link

Link copied!

Thanks Efialttes,

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

Like (0)

Report
Copy link

Link copied!
Hi!

Following @Pstork1 recommendation, I would replace currentassigned value

item()?['Stukprijs']

and use this expression instead

formatNumber(item()['Stukprijs'],'$#.00')

Hope this helps

Was this reply helpful? Yes No
Rbovenkamp 28 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hi again
There is a typo on the expression
formatNumber(item()?['Stukprijs'],'$#.00')
TRy now

Was this reply helpful? Yes No
Rbovenkamp 28 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much! That worked!

Was this reply helpful? Yes No