You’re offline. This is a read only version of the page.
Hi,
I am relatively new to Power Automate and I am a numb business person so hopefully you understand.
I have a sharepoint list with a column with revenue numbers (formated in currency). In sharpoint the numbers are formatted
correctly (e.g. 40.520,86 € - I am from Germany)
Now I have created a flow which sends an email and it should put the revenue number from that field in the Email Body.
It all works fine but the number is formatted like this 40520.86
What do I have to do (and where) to get the number in the Email body formated to a German number Format?
Thanks a lot for you help!
Chris
soory the screenshot was not attached
The error message is:
BadRequest. The variable 'PowerRevenue' of type 'Integer' cannot be initialized or updated with value '0' of type 'String'. The variable 'PowerRevenue' only supports values of types 'Integer'.
Thanks for the reply!
I have some troubles with initializing the variables - I believe I have to do this first?
Sometimes the value is zero and then I get the following error when running the flow:
The column in the sharepoint list is formatted as currency - do I see that currectly that it is translated into a string?
Hello @chz
In this post by @Pieter_Veenstra you will find the solution: https://powerusers.microsoft.com/t5/Building-Flows/Displaying-a-number-as-Currency-or-Decimal/td-p/176185
You should have to create an expression like the following:
concat(div(variables('value'),100),'.',if(less(mod(variables('value'),100),10),concat('0',mod(variables('value'),100)),mod(variables('value'),100)),' €')
where variables('value') should be "Power Revenue", "Storage Revenue" or "TSS Revenue" values from SharePoint.
Hope it helps!
Ferran
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
