Unanswered

Power Autome Cloud - converting to float

(0) Share

Report

Posted on by loparque1

Hi, I'm using a flow where I get a data from AI from pdf file where theorically I get a number using this expression:

replace(replace(replace(replace(outputs('Extract_information_from_forms')?['body/responsev2/predictionOutput/labels/Total/value'],',',''),'.',''), ' ',''),'$','')

and then y fill in Excel the numbers (yellow highlighted)

If I envolve this formula in IsFloat(myexpression) I get TRUE as values

But, when I try divide by 100 with this formula

div(replace(replace(replace(replace(outputs('Extract_information_from_forms')?['body/responsev2/predictionOutput/labels/Total/value'],',',''),'.',''), ' ',''),'$',''),100) I don't get syntax error but the flow finally give me an error and the data does not finish in the Excel

What am I doing wrong?

regards

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Hi @loparque1 ,

The first parameter required by isFloat() is string, so it can successfully return true, but the first parameter required by div() is integer or float. So, your expression cannot be used as the first parameter of div(). You need to convert it with float().

Best Regards,
Dezhi

Was this reply helpful? Yes No
loparque 2 on at

Like (0)

Report

Dezhi, thanks a lot!! It works!
My error was isFloat() returned True if the parameter is a float, not a string. I found the url with functions documentation now to learn about all the functions!!
Thanks again!

Was this reply helpful? Yes No