Unanswered

Need help figuring out how to output a calculated column (currency) with Start and Wait for an approval action

(0) Share

Report

Posted on by bbeaver

I am attempting to build a flow that automates a purchase approval process. Everything seems to be working, but whenever Power Automate sends an approval in Teams or Outlook, it shows the "Total Cost" calculated column I'm using with extra zeros. I have tried researching multiple ways to fix this, but I don't think I am using the "Float" or "Int" expressions correctly or in the right place. Below is a screenshot of the column settings for the calculated column and the flow. I am sure this is an easy fix, but I am very new to Power Automate, so I have no idea what I am doing. Please Help!!

Here is the approval message from the flow.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report

Try function formatNumber()

https://learn.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#formatNumber

Was this reply helpful? Yes No
bbeaver 4 on at

Like (0)

Report

Where would I use formatNumber? Does it go in the flow somewhere or in the column settings?

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report
I'd suggest having a look at the expression formatNumber. The below examples would round to the nearest 2 decimal places, and add a comma between each thousand.

//if you have a number to pass in formatNumber(1222212930.200299, '###,###.00') //if you have a number (as a string) to pass in formatNumber(float('1222212930.200299'), '###,###.00') //You would replace the number with your calculated field

Was this reply helpful? Yes No
Chriddle 8,443 Super User 2025 Season 2 on at

Like (0)

Report

In your "Start appoval" details, replace the dynamic value "Total cost" with the expression

formatNumber(<Total cost>, '0.00')

(Replace <Total cost> with the dynamic value)

Was this reply helpful? Yes No
bbeaver 4 on at

Like (0)

Report

Thank you so much. I was trying to figure this out for 6 hours yesterday instead of just posting on here in the first place. I used formatNumber(float(outputs('Update_item')?['body/Total_x0020_Cost']),'##,###.00') and it worked like a charm. Next time, I will post immediately instead of wasting so much time. Again, thank you!!!

Was this reply helpful? Yes No