Hi - I'm using the template "Periodically e-mail a Power BI scorecard status", but I'm not able to figure out how to format the values. They are formatted correctly in the Power BI scorecard, but translating differently in the flow. Example is attached.
How can I format the values?
J. Gray
Where would I apply the condition? I'm not sure of the steps and where to find any tutorials on writing an expression for power automate. Anything you can point me to would be helpful.
Hi - not all the values are percentages.
You can add a condition, for example, if the number contains "." then its percentage and if not then its number
Hi - the additional issue is that some of those values should be percentages and some just numbers with a comma. I don't know how to format them individually. I was thinking maybe there is a setting that picks up the format from the source of the data vs. changing them.
Hi @jgray2 ,
My guess is you need to change Value and Target to percentage, you can use the Format Number action to get the desired result
https://www.shahryarsultan.com/2021/03/How-to-Format-Number-to-Percentage-in-PowerAutomate.html
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2