How to convert string to integer

Like (0) Share

Report

Posted on 3 Jan 2024 07:35:19 by lisa_garcia

Hi everyone,

I am using a AI model to extract information from an invoice document.

One of the extracted informations is the total value of the invoice, the extracted information as value is a total number, but the text result is the actual correct output since it´s providing the currency and the comma.

I now want to use the extracted text, convert it to int to use it in a condition to check, so if the amount is higher then 1000 a specific action has to happen.

Can anyone help me in setting up the correct flow?

I have the same question (0)

All responses (8)

Answers (1)

lisa_garcia 33 on 08 Jan 2024 at 14:25:51

Like (0)

Report

Re: How to convert string to integer

Thanks so much @v-jefferni it worked!

Was this reply helpful? Yes No
Verified answer

v-jefferni on 05 Jan 2024 at 06:23:00

Like (1)

Report
Re: How to convert string to integer

Hi @lisa_garcia ,

Try below and you can get the currency:

formatNumber(float(substring(outputs('Compose'),0,sub(length(outputs('Compose')),1))),'$ #,###.00')

Best regards,

Was this reply helpful? Yes No
lisa_garcia 33 on 04 Jan 2024 at 14:59:20

Like (0)

Report

Re: How to convert string to integer

Hi @v-jefferni
thanks so much for helping me!
So I´m geeting a result, but still missing the two digits.. How do I get the number right?
Tried float but it isn´t working...

regards

Was this reply helpful? Yes No
v-jefferni on 04 Jan 2024 at 01:33:07

Like (0)

Report
Re: How to convert string to integer

Hi @lisa_garcia ,

Just need to extract substring from the first digit:

int(substring(outputs('Verfassen'),0,sub(length(outputs('Verfassen')),1)))

Best regards,

Was this reply helpful? Yes No
lisa_garcia 33 on 03 Jan 2024 at 12:35:07

Like (0)

Report

Re: How to convert string to integer

hi @v-jefferni
It almost works but I´m missing a digit
Any idea?

Was this reply helpful? Yes No
v-jefferni on 03 Jan 2024 at 09:54:23

Like (0)

Report
Re: How to convert string to integer

Hi @lisa_garcia ,

So, the currency symbol is in the end. You can edit the expression as follow:

int(substring(outputs('Verfassen'),1,sub(length(outputs('Verfassen')),1)))

Best regards,

Was this reply helpful? Yes No
lisa_garcia 33 on 03 Jan 2024 at 09:36:37

Like (0)

Report

Re: How to convert string to integer

Hi @v-jefferni
I tried your solution but get another error:
the compose 2 looks like this:
int(substring(outputs('Verfassen'),2,sub(length(outputs('Verfassen')),2)))

Was this reply helpful? Yes No
v-jefferni on 03 Jan 2024 at 08:55:53

Like (0)

Report
Re: How to convert string to integer

Hi @lisa_garcia ,

To convert currency string to number, you need below expression:

int(substring(outputs('Compose'),2,sub(length(outputs('Compose')),2)))

Best regards,

Was this reply helpful? Yes No

Community site session details

How to convert string to integer

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Tom Macfarlan – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

How to convert string to integer

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Tom Macfarlan – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates