Power Automate Flow Switch or condition statement fails to recognize a number value in a SharePoint Field. There is no VALUE options for this numeric field.

(0) Share

Report

Posted on by jholmes724

Scenario:

Data Source: SharePoint

Field Name being referenced using Dynamic Content: IsCompleted (In SharePoint this is a numeric value with no decimal Places)

Issue:

So I have to use the Dynamic Content IsCompleted because there is not IsCompleted Value option.

The execution of template action 'Switch' failed: The result of the evaluation of 'scope' action expression '@triggerBody()?

'IsCompleted']' is not valid. It is of type 'Float' but is expected to be a value of type 'String, Integer'.

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (2)

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

In Power Automate a floating point number is not automatically converted to an integer. Since you are using an integer in the comparison you need to put int() around the value to convert it to an integer. Or change you comparison to use a floating point number.

Was this reply helpful? Yes No
jholmes724 20 on at

Like (0)

Report

And where do I put this int() function in the flow? On the switch control? in code somewhere? If in code Would it be something like this, and exactly where would I put this code?

"expression": "@triggerBody()?Int(['IsCompleted'])"

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report
Line this

"expression": "@int(triggerBody()?['IsCompleted'])"

Was this reply helpful? Yes No
jholmes724 20 on at

Like (0)

Report

Ok that will probably work however, I believe I gave you a very detail description of the issue. So why are do you not answer all my questions? Your responses are just one-liners that are not totally helpful. I am sure you know that the code view is read-only. So how am I supposed to edit this code?

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

I'm sorry, I didn't see any other questions. Just the question that your switch wasn't working because it was expecting an integer and was receiving a Float. What other questions do you have?

If you are trying to do a switch on a number then you need to convert the number from a float to an integer in the spot where you are putting the float.

Was this reply helpful? Yes No