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

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Jouv

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

Was this reply helpful? Yes No
Jouv 5 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

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

Was this reply helpful? Yes No