web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate flow to convert from S...

Power Automate

Answered

flow to convert from STING value into INT does not work as needed

(0) Share

Report

Report

Posted on by frank2709

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????? 😕

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:

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.

Was this reply helpful? Yes No
Verified answer

frank2709 16 on at

Like (0)

Report
Copy link

Link copied!

Many many thanks !!!! I is working 🙂
Thank you very much 🙂

Was this reply helpful? Yes No

Join the conversation