Using a Excel table value in a conditional statement

[Jacob_Col]

I have gotten values from an excel table that I am trying to use in a conditional statement.

When it gets to the conditional it gives me an error saying that it is unable to read this as it is a string value compared to a float.

[eric-cheng · Accepted solution]

Hi @Jacob_Col ,

You can try using the float() expression

float(outputs('Compose'))

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[Jacob_Col]

Thank you for the suggestion. 

Tried this out and got a different error (Below)

I tried adding the "Current item" of the "Apply to each 4". Yet this resulted in the flow being unable to even save. do you have any advice on this?

[eric-cheng]

Hi @Jacob_Col ,

Can you post up the entire flow.  Not sure why there are two loops.

The condition should be in the same loop as the Compose.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn