Unanswered

Having issues with Converting String to float or integer with Power Automate

(0) Share

Report

Posted on by Tristan21

I'm having error or not expected result when I do have, with the following expression.

I have a String with '10,50' which is equivalent to '10.50'. But whatever writing with comma or point, this ends with the same error.

int('10,50') -> 1050
float('10,50')-> 1050
Sub( ofloat, ofint) -> fails

int('10.50') -> error "InvalidTemplate. Unable to process template language expressions in action 'Integer_part' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
float('10.50'): ActionConditionFailed. The execution of template action 'float' is skipped: the 'runAfter' condition for action 'Integer_part' is not satisfied. Expected status values 'Succeeded' and actual value 'Failed'.

In conclusion, I suppose '10.50' is better than '10,50' to write a decimal number, howerver it fails also miserably. Of course I added a compose action to replace ',' by '.' but it didn't fix neither.

So, would it ring you any idea that I could test ? Thank you in advance for your reading.

At the end of the day I was trying to addToTime with decimal number of year, this is the reason I have to split int and frac part.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

manuelstgomes 6,625 on at

Like (0)

Report

Hi @Tristan21

You need the period instead of the comma to convert to a float. This will work:

float('10.50')

The second error is not related to the function itself but with something else. can you please share your Flow with those errors so that I can look?

Cheers
Manuel

------------------------------------------------------------------
If I have answered your question, please mark it as "Accept as Solution." It will help other members finding the solution faster. If you like my response, please give it a Thumbs Up. ?
Otherwise, reply to it, and the community will do its best to help you.

Was this reply helpful? Yes No
Tristan21 69 on at

Like (0)

Report

Hello Manuel,
Firstly, thank you for your reading and feedback. I've meanwhile opened a support request about it , ... still in process.
Just to clarify my initial need: Split the int part and frac part of decimal number that I receive in string "10,50" (-> get the 10 and get the 0,50.).
In the 80's that was Int(number) and Frac(number) functions available on Ti57 programmable calculator 😉 quite simple at that old time ).

It's possible that I'm having regional settings conflict between french/English (, or .). I say so because int(1.5) isn't working neither.
However the Solution /workaround I see now is making the split my self at the string level like ;
IntPart= ( int(first(split(StringNumber, ','))) ;
FracPart=mul(int(last(split(StringNumber,','))),10)
That'll make for now

Was this reply helpful? Yes No
Verified answer

Tristan21 69 on at

Like (0)

Report

After few attempts, here is the solution I came with regarding how to extract respectively Int and Frac part from decimal number. I miss understood the Int function, it's not aim to provide Int part but to transform whole number as string into whole number( int('10')=10. Same for float, ... decimal number as string into decimal number float('10.5')=10.5. Once said it seems obvious 😉
So the key function is formatNumber, which allows to limit the number expression into a whole number: formatNumber( 10.5 , '0')=10.
The frac of 10.5 = 0.5= float('10.5')-formatNumber(float('10.5'),'0')

Was this reply helpful? Yes No
arcado 320 Moderator on at

Like (0)

Report

I have a problem as I am reeding excel cell it says for ex 10.57 power automate gives me 1,057 as float how can I fix that?

Was this reply helpful? Yes No