Format values within a .csv table

(0) Share

Report

Posted on by bchager6

132

I've created a Flow with an, "On Power BI button clicked" trigger.

From there, I create an array, append fields to it from Power BI, then create a .csv table.

I need to format the first 3 fields within the Append to array action as decimal numbers with 3 decimal places, and the 4th field as a percentage with 1 decimal place.

Can anyone recommend the best approach here?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (1)

Report
You can use the formatNumber function in an expression, for example:

formatNumber(234.12324322342422,'0.000') 234.123 formatNumber(0.467, '00.0%') 46.7%

Or you can use the the Format number action:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
bchager6 132 on at

Like (0)

Report

Thanks for your feedback. I'm able to format the numbers the way I want to, and the outputs look good, but the circled number below is what's appearing in my csv table, which I create as a step right after the Apply to each below. Do you have any idea why?

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (1)

Report

Please check the following:
After formatting the number 1.525306, include the output of the action in the Append to Array, for example:
Here is the runtime output of the Format number action returning 1.525:
Here is the runtime output of my Append to variable action showing the value of 1.525:

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
bchager6 132 on at

Like (0)

Report

@ekarim2020 This has been very helpful. Thank you.

Was this reply helpful? Yes No