Hi everybody,
I create a flow that gets data from D365 Finance and Operations and send emails to managers.
Here is an email example:
As you can see I send the Net amount could be easier to read if I format it as maybe: 218 174 €.
I saw and read the format options here: https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings#code-try...
I can use, for example:
formatNumber(variables('myFloat), 'N', 'en-US')
The main issue is that the data I want to format (the line net amount) can't be added in the formatNumber function... but only the body or value of the PO lines details (from Finance and Operations).
I can customise the columns of the table as wanted, with the net amount... but without formatting it 😞
Here is the email action, where I can only put the Outputs of my action 'Create HTML Table':
Can anyone give me tips on how I can handle this format number?
Thanks,
Solved! Go to Solution.
Hi @Frog64,
You could use the expression item()?['columnName'] to get a specified column value of current item, for example:
item()?['Net_Amount']
Then if you want to convert the number to a monetary unit of the euro, the format specifier should be "C" or "c", and the symbol should be fr-FR:
formatNumber(item()?['Net_Amount'], 'C', 'fr-FR')
Result:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Frog64,
You could use the expression item()?['columnName'] to get a specified column value of current item, for example:
item()?['Net_Amount']
Then if you want to convert the number to a monetary unit of the euro, the format specifier should be "C" or "c", and the symbol should be fr-FR:
formatNumber(item()?['Net_Amount'], 'C', 'fr-FR')
Result:
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It solves my issue, thanks a lot.
I am still fairly new to power automate and learning daily. I am not sure how to apply this solution to my flow. I really need to get rid of these trailing zeros. Does the number of decimal places for the calculated columns in my list matter? If not, how do I apply your solution to my flow. Thanks in advance!
SharePoint list calculated column settings:
Flow:
HTML table in Email: