You’re offline. This is a read only version of the page.
16
Hi All,
i am trying to parse e-mail invoices (html format) and put some variables like invoice nr, date and so on in a SharePoint online list.
This works very well.
One column in SharePoint online is configured as "currency" and of course does expect an int value (not a STRING)
Here comes the challenge: every parsed value is interpreted as STRING. so good so far.
The finally parsed value for the invoice amount is: 66,76 (as a STRING)
(the comma is correct and should not be changed nor removed - I am from Germany)
so I added a further initialize variable action with the following expression: int(variables('mny')) to convert the STRING into INT
Flow works without errors, but it removes the comma
with this configuration I received an expense of 6.676,00 € instead of 66,76 € in SharePoint Online.... not so good.
What am I doing wrong????? 😕
Hi @frank2709,
Because in the context of English users, a comma is considered to be an amount digit separator, not a decimal separator, so the "66,76" will be considered to an integer "6676".
As a workaround, you could use replace() function, convert "," to ".", convert "." to ",". Then use number format action converts the number to Germany format:
Share
Report
All responses (
Answers (
replace(replace(replace(outputs('Compose'),',','~'),'.',','),'~','.')float(outputs('Compose_2'))
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.
#1
WarrenBelz
146,635
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
