Flow conditions not working

[livingstonep]

We have a flow with two conditional approvals, but they must run before the flow can continue on to the other approvals which are not conditional.

So first we run the two Conditional approvals, one for Health & Safety, and one for Information Security

Then before continuing onto the next approval,  we check that:

Either:

        Health & Safety not required (Yes/No Column = "No")

    or

       (

       Health & Safety required
       AND

       Health & Safety approval value = "Pass"

       )

OR

        Information Security approval not required (Yes/No Column = "No")

    or

       (

       Information Security required
       AND

       Information Security approval value = "Pass"

       )

The field names in the list are:

• H & S Approval Required:
  • Field Type: Yes/No
  • Field name: H_x0026_S_x0020_Approval_x0020_R

• H & S Approval
  • Field Name: H_x0026_S_x0020_Approval
  • Field Type: Choice
  • Field values:
    • Not applicable
    • Pass
    • Fail

• InfoSec Approval Required:
  • Field Type: Yes/No
  • Field name: InfoSec_x0020_Approval_x0020_Req

• Information Security Approval
  • Field Name: InfoSec Approval
  • Field Type: Choice
  • Field values:
    • Not applicable
    • Pass
    • Fail

so we have this conditional step in our Flow:

but when we run the flow, that Condition alwayes returns false.

so we tried looking at the internal values with extra debugging conditional steps:

expression: equals(triggerBody()?['H_x0026_S_x0020_Approval']?['Value'], 'Not applicable')

test: is equal to

test value true

Unfortunately, even though the field value for that column(for record ID=13)= "Not applicable" - that test always returns false.

And the same for a debugging test on InfoSec Approvali value...

So what are we doing wrong or missing here?

thanks

Philip

[v-bacao-msft · Accepted solution]

Hi @livingstonep ,

When configuring Yes/No field or Choice field in Condition, we need to pay attention to the following points.

If the field type is Yes/No, we need to use true/false to determine the field value.

If the field type is Choice, we need to use Choice Value to determine the field value.

Please take a try again.

Best Regards,