Unanswered

Help building conditional logic for my flow

(1) Share

Report

Posted on by sam888

Hi,

I am trying to build a flow that checks 3 sharepoint choice dropdowns. If all three columns contain a value of 'Approved' or 'NA', I want a teams notification sent. If they have any other value, nothing happens.

I've experimented with different yes/no settings and nothing is working the way that I want. This is my current setting and it states that ActionBranchingConditionNotSatisfied even thought all values are set to 'Approved'.

I was hoping someone could help me think through this. I obviously don't have the logic right or need to use some other control.

Thanks!

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

David_MA 14,761 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I would pass your three columns through a compose action so you can easily see what the values are. When you use is equal to on a string, it needs to be an EXACT match including case for it to be considered equal. If your values pass approved instead of Approved, it is not equal.

Was this reply helpful? Yes No
sam888 6 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Thank you for the suggestion. I had read something about that but honestly I am having trouble wrapping my head around how to set up the compose and then use it with my condition. I tried ChatGPT and was given this for compose:
@And(
or(equals(triggerOutputs()?['body/AIApproval'], 'Approved'), equals(triggerOutputs()?['body/AIApproval'], 'NA')),
or(equals(triggerOutputs()?['body/ELApproval'], 'Approved'), equals(triggerOutputs()?['body/ELApproval'], 'NA')),
or(equals(triggerOutputs()?['body/SPEDApproval'], 'Approved'), equals(triggerOutputs()?['body/SPEDApproval'], 'NA'))
) and then it suggested the condition setup that I have shown above. When I paste the code into compose, this is what it looks like:
{
"type": "Compose",
"inputs": "@and(\n or(equals(triggerOutputs()?['body/AIApproval'], 'Approved'), equals(triggerOutputs()?['body/AIApproval'], 'NA')),\n or(equals(triggerOutputs()?['body/ELApproval'], 'Approved'), equals(triggerOutputs()?['body/ELApproval'], 'NA')),\n or(equals(triggerOutputs()?['body/SPEDApproval'], 'Approved'), equals(triggerOutputs()?['body/SPEDApproval'], 'NA'))\n)\n",
"runAfter": {}
}

When I test the flow, it doesn't work as expected. The Inputs and Outputs simply say false.

Do you have any code advice or suggestion for a good video to explain how to set these up? I haven't found any that make it very clear or use it in a way that I am trying. Thanks!

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @sam888

You want any of the values should be Approved or N/A, so it should start with an OR condition then AND with your groupings. Try the below.

Was this reply helpful? Yes No