Answered

Embedding an AND condition in an OR trigger condition

(0) Share

Report

Posted on by HannahMS

I'm currently creating multi level approval flows (the item is created then goes for Head of Service approval and then Director approval), which I've broken into separate flows for each level of the approval process and the responses update a SharePoint list.

Each flow starts with a 'When an item is created or modified' trigger, which I want to only trigger when it hasn't already been through that stage of the approval process or if the person who has raised the request has submitted more information. It seemed like it was working, but I tried to break it apart and then it got stuck in a loop. I've tried rewriting it, but it's not valid. Can anyone help me with getting this trigger condition to work?

@OR(and(equals(triggerOutputs()?['body/HoSApproval'],'More information required'),equals(triggerOutputs()?['body/Resubmitted'],'Yes')), and(equals(triggerOutputs()?['body/HoSApproval'],null)))

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report
Re: Embedding an AND condition in an OR trigger condition

Hi @HannahMS

Pls try this one:

@OR(and(equals(triggerOutputs()?['body/HoSApproval'],'More information required'),equals(triggerOutputs()?['body/Resubmitted'],'Yes')),empty(triggerOutputs()?['body/HoSApproval']))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
HannahMS 12 on at

Like (0)

Report

Re: Embedding an AND condition in an OR trigger condition

Hi @ManishSolanki

That seems to have done it - thanks!!!

How would I then do the next stage of approval where it will check the same 'More information' values, but when it checks if the 'Director Approval' value is null it will also need to check that the HoS is showing 'Approved'?

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (0)

Report

Re: Embedding an AND condition in an OR trigger condition

Hi @HannahMS

Could you please explain a bit?

Was this reply helpful? Yes No
HannahMS 12 on at

Like (0)

Report

Re: Embedding an AND condition in an OR trigger condition

Hi @ManishSolanki

So once a request has been approved by the Head of Service, it triggers a whole new flow to get approval from the relevant Director. Because it's a separate flow with a new trigger, I want to make sure if only triggers if the Director approval value is null, but the Head of Service value is set to 'Approved'. It still has the same 'More information' condition though.

Is it something like this?
@OR(and(equals(triggerOutputs()?['body/DirectorApproval'],'More information required'),equals(triggerOutputs()?['body/Resubmitted'],'Yes')),(and(equals(triggerOutputs()?['body/HoSApproval'],'Approved'),empty(triggerOutputs()?['body/DLTApproval'])))

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,089 Super User 2025 Season 2 on at

Like (1)

Report
Re: Embedding an AND condition in an OR trigger condition

Hi @HannahMS

Pls try this one:

@OR(and(equals(triggerOutputs()?['body/DirectorApproval'],'More information required'),equals(triggerOutputs()?['body/Resubmitted'],'Yes')),and(equals(triggerOutputs()?['body/HoSApproval'],'Approved'),empty(triggerOutputs()?['body/DLTApproval'])))

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
HannahMS 12 on at

Like (0)

Report

Re: Embedding an AND condition in an OR trigger condition

Hi @ManishSolanki

That seems to have done the job! I really, really appreciate your help with this 😃

Thanks

Hannah

Was this reply helpful? Yes No