How to add a Trigger Condition to related tables in the Filter Rows condition to avoid unneeded flow runs

(0) Share

Report

Posted on by Mustaque_Ehiya

142

Hi team,

I am looking to run the flow ONLY if the related table condition is met. currently we have 50% of the triggered runs canceling because of unmet conditions in the related table.

Requirement: Currently the flow is triggered against "Incident Resolution" table and in the below conditions we check the related table "Incident" for status code and phone no availability. If those conditions are not met, we are cancelling the flow.

is there a way to add the related table conditions in the Trigger itself so that we can avoid the unneeded flow runs.

Conditions fyr.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

JonDoesFlow 1,304 on at

Like (0)

Report

Hi,

I wrote a blog post on how to build trigger conditions using the Filter Array step in Power Automate, I think this might help you:

https://www.jondoesflow.com/post/filter-array-ftw

If I have helped solve your issue, please accept this as a solution and thumbs up my reply.

Thanks.
www.jondoesflow.com

Was this reply helpful? Yes No
Mustaque_Ehiya 142 on at

Like (0)

Report

Hi @Jondoesflow - Thanks for responding. The solution you shared is related to the expression for main table we are triggering which we are already using it, but primarily I am looking for format/expressions if available to filter based on Related tables - like the way we use in the Expand Query which is available for other Tasks.

Was this reply helpful? Yes No
Mustaque_Ehiya 142 on at

Like (0)

Report

Hello Team - do we have this feature in Power Automate or should we raise this in Idea ?

Was this reply helpful? Yes No
Mustaque_Ehiya 142 on at

Like (0)

Report

hi Team - raised an idea for this feature - Microsoft Idea (dynamics.com)

Was this reply helpful? Yes No
RubenL 7 on at

Like (0)

Report

Hi!

Have you find a solution already?

Was this reply helpful? Yes No
Mustaque_Ehiya 142 on at

Like (0)

Report

Nope, I raised an idea but still not picking up votes.
Appreciate if you could vote if you are looking for that feature - Microsoft Idea (dynamics.com)

Was this reply helpful? Yes No