Have been trying to convert a value shown as a percentage in a SharePoint list in Power Automate so that it displays correctly in an email.

Originally the number (50%) although displaying correctly in the list was then coming out via Power Automate email as 0.500000000000000.

I therefore added initialize variable and used that value as an output using the expression:

formatNumber(float(triggerBody()?['Non_x0020_Conf_x0020__x0025_']), '0.00')

It is now coming out as 0.50.

I just want it showing as 50 – any ideas? I can see that the 0.00 is probably defining it but tried changing it to just 0 and then the value was 1. So any suggestions for correct syntax welcome.

1 Answer 1


Try using this expression:

formatNumber(mul(float(triggerBody()?['Non_x0020_Conf_x0020__x0025_']), 100), '0.00')

It will multiply the float number by 100 and then format it with two digits after decimal point.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.