You’re offline. This is a read only version of the page.
Announcements
17
Hi all,
I am creating an automatic report based on values which are created in Microsoft list. The Microsoft list contains float values with comma for decimal values (so 4,73 instead of 4.73). When I run my script it however returns the values in an American format (so 4.73 instead of 4,73). I've tried to use formatNumber but it sends back a string value. After converting it to a float it just removes the , (so 4,73 becomes 473).
Ideally I wouldn't need to convert anything as the values in my Microsoft list are already in the right format. But somehow power automate doesn't see it that way.
The output of a report can be seen in attachment as well as some values of my Microsoft list
Hi @jasper_g ,
I have Created sample For You.
Please Use this Expression to Convert American format numbers to European format.
Share
Report
All responses (
Answers (
formatNumber(triggerOutputs()?['body/TestFNumber'], '0,0', 'is-is')
