Power Automate - Find workflow runs action

Advanced Uses
1

Hi everyone, I’m curious about something with the Power Automate integration. Do the “Find workflow runs” action filters work as a logical AND or OR operator? In my testing It seems to be an OR, finding workflow runs even when I have two filters attached.

I’m seeing that in the API documentation it is also an OR, stating:

“…if there are multiple form field values, then workflows that match any of them will be returned.”

My main question is would there be a way to make it an AND filter? I want it to only find workflow runs based on multiple field properties containing certain text. I’d be ok using the API for this in an HTTP request as well.

2

Hi @kdesilva

I just want to clarify what you are looking for.
You want to be able to find a workflow run based on more than one form field value
ie,
First Name contains ‘Tarik’
AND
Surname contain ‘Ali’

And you would be happy to do this either via the API or through Power Automate?
If that is the case I can see if this is possible or not.

Thanks
Tarik

4

Yes, that would work for my use case.

As an addition, I would love to have more control over it. Ability to change contains to equals, not equals, etc.

If it’s not possible with the existing action in Power Automate the API would work perfectly fine.

5

Can you send me a quick loom video of how you have this setup currently? I know its possible to do this in Zapier, but taking a look at Power Automate first before checking via the API.
If you would prefer you can email the screen recording directly at tarik@process.st

Thanks
Tarik

6

@kdesilva

I just tested our find workflow runs API call (instead of the ‘find workflow runs’ action in our connector) in Power Automate and it is also using an ‘OR’ condition. (IE… it returns workflow runs that match any criteria instead of all search criteria)

7

Looks like there may be a way around this :grin:

If you create a hidden field and populate the default value of the hidden with a series of appended variables (that contain the values from all the form fields in the workflow run you want to search by) you may be able to use a single search (on the hidden field) and avoid the ‘OR’ search issue.

8

This is a great workaround Jeff thanks for posting it!

9

This is exactly what I ended up doing for my client. Would love to see the functionality built into the API though!

I can still send the old setup to you @Tarik if needed.