web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate Zero value not displaying

Power Automate

Answered

Zero value not displaying

(0) Share

Report

Report

Posted on by rosscortb

196

Hello,

Read a few articles on this issue but none resolve it. How do I add the zero on after the 7 in total price? it should go to two decimal places.

Code I am using against price is

If(empty(item()?['Total_x0020_Price']),null,concat('£',float(item()?['Total_x0020_Price'],'en-uk')))

Thanks

Ross

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

v-chengfen-msft on at

Like (0)

Report
Copy link

Link copied!
Hi @rosscortb ,
Please try:
If(empty(item()?['Total_x0020_Price']),null,concat('£',formatNumber(float(item()?['Total_x0020_Price'],'en-uk'),'C2','en-US')))

Best Regards
Cheng Feng

Was this reply helpful? Yes No
rosscortb 196 on at

Like (0)

Report
Copy link

Link copied!

@v-chengfen-msft

Thanks, get the zero showing but in dollars changed last bit to en-uk but get this now?

Was this reply helpful? Yes No
Verified answer

Chriddle 8,513 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
'en-uk' simply is not a valid locale.
Don't concatenate the Pund character into the string! This is already done with the 'C2' param.
Simply use:

formatNumber(12.8,'C2', 'en-GB')

outputs '£12.80'

Was this reply helpful? Yes No
rosscortb 196 on at

Like (0)

Report
Copy link

Link copied!

@v-chengfen-msft @Chriddle
Thanks both for your help. Got it working. Cheers

Was this reply helpful? Yes No

Join the conversation