Unanswered

Control Conditions defaulting to False

(0) Share

Report

Posted on by Uzziss

I am trying to automate our handover at work so that it changes the status on a list once 2 conditions are met. The flow is checking that the Status column which is a dropdown column is equal to "Service Restored" and that the "Incident Age" is greater or equal to "8"

When I run the flow it runs fine, however it says the conditions are false despite there being items in the list that meet the above criteria. This is what the condition looks like. I've tried all different ways of entering the value but the output still always says it is false. Does anyone know what I am doing wrong.

I have the same question (0)

All responses (12)

Answers (0)

Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

Re: Control Conditions defaulting to False

Assuming that Status is a dropdown I suspect the problem is that you are picking "Status" and not "Status Value" from the dynamic content. Status will be the object which includes the value. But for comparison you want just the value itself.

Was this reply helpful? Yes No
Uzziss 14 on at

Like (0)

Report

Re: Control Conditions defaulting to False

Thanks Pstork. I figured out that I was calling the wrong input for Status. I have changed it to Status Value and that first condition works when it is on it's own. When I add the 2nd condition for the Incident Age it goes back to being false.

Was this reply helpful? Yes No
Uzziss 14 on at

Like (0)

Report

Re: Control Conditions defaulting to False

I'm not sure if the fact that my Incident Age field is a Calculated Field. Could my Flow be seeing the formulae and not the value that is being output to the view.

Was this reply helpful? Yes No
VictorIvanidze 12,834 on at

Like (0)

Report

Re: Control Conditions defaulting to False

Remove the single quotes before and after 8

Was this reply helpful? Yes No
Uzziss 14 on at

Like (0)

Report

Re: Control Conditions defaulting to False

If I remove the single quotes I get the following error.

Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'.

Was this reply helpful? Yes No
VictorIvanidze 12,834 on at

Like (0)

Report

Re: Control Conditions defaulting to False

Convert "incident..." to int using int() function.

Was this reply helpful? Yes No
Uzziss 14 on at

Like (0)

Report

Re: Control Conditions defaulting to False

This is what my Condition looks like now

I don't get an error but the output is still false even though the incident date on the test case is 22.

Was this reply helpful? Yes No
Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

Re: Control Conditions defaulting to False

IN general you won't be able to use calculated fields from SharePoint in Power Apps. Its also probably an issue that the field is being interpreted as text, not a number.

Was this reply helpful? Yes No
Uzziss 14 on at

Like (0)

Report

Re: Control Conditions defaulting to False

Is there any way to get the flow to check what the modified date is to see if that is more that 8 days ago?

Was this reply helpful? Yes No
VictorIvanidze 12,834 on at

Like (0)

Report

Re: Control Conditions defaulting to False

Hi @Uzziss,
no - at left side int(...) and at right side just 8.

Was this reply helpful? Yes No