Answered

Convert string from array to integer

(0) Share

Report

Posted on by Jouv

Hello Community,

I'm parsing a table out from a mail with power automate. I just need to get the last item of the table. I managed to get this specific row and manage do store it into a variable.

But i failed to convert it to integer.

My data can takes several forms like : 480 000 or just 0 or -0,03 or 452 000,23.

All i want is to convert the string into integer in order to make some logical test with the data after.

Today i have error when compose data with int() formula.

Best regards,

Kair0

All responses (3)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (1)

Report
Re: Convert string from array to integer

Hi @Jouv :

The key is that 125.2, -0.03 and other decimal values are all floating-point numbers, they are not integers.

You'd better try:

float(trim(output(var)))

Best Regards,

Bof
Jouv 5 on at

Like (0)

Report

Re: Convert string from array to integer

Hello @Mira_Ghaly ,

trim does not the same thing like in excel. It just remove blank space before and after not between.
when my variable is equal to 125,2 or -125,25 or -0,03, int(trim(output(var))) will fail.
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Convert string from array to integer

@Jouv

Did you try to use the trim expression before converting to INT?