Hi there. I don't expect this to be super complicated but I'm not totally clued up on Flow expressions just yet and have a question. I have a Sharepoint Created / Modified trigger and I currently have a handful of Condition > Terminate functions to kill off the flow under certain conditions, and would like to make use of trigger conditions instead in order to save flow runs. I'm just trying to wrap my head around the terminology though. Could someone clarify what the actual expression would be if I wanted the flow to ONLY run when:
STATUS column = Pending Approval
APPROVER column contains information
It's pretty simply doing this with the terminate condition, and I know / think the beginnings of the expression will be something along the lines of the below, but expanding this to accommodate the two pieces of criteria with AND operator I'm unsure about. Can anyone advise?
The following code works for me. You may have to play with the field names if yours are different. But this is the syntax.
@And(equals(triggerBody()?['ApprovalStatus'], 'Pending'),equals(empty(triggerBody()?['Approvers']), false))
He's building a Trigger condition. There is no "Add" in that dialog yet. You have to build it as a string.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.