How to Trigger a Power Automate flow for N:N related tables?

Like (0) Share

Report

Posted on 17 Feb 2025 14:07:58 by Surendere_24

In FSM, we have two tables—Accounts and Functional Locations—with an N:N relationship.

I want to trigger a Power Automate flow when a Functional Location is associated with an Account. Specifically, the flow should be triggered whenever a Functional Location is added to an Account.

I attempted to achieve this by adding a trigger on the intermediate (relationship) table between Accounts and Functional Locations, but it did not work as expected.

Could you please suggest an alternative approach to achieve this?

waiting for suggestion

Categories:

Business Process Flows

All responses (1)

Answers (0)

Infamous_Let 155 on 17 Feb 2025 at 14:21:09

Like (0)

Report

How to Trigger a Power Automate flow for N:N related tables?

A good alternative is to use the "When a row is added, modified, or deleted" trigger on the junction table while ensuring the correct scope and filters. If that’s not working, you could try a scheduled flow that periodically checks for new associations or use a Dataverse Plugin/Workflow to create a shadow field that updates when a Functional Location is linked to an Account. This shadow field can then trigger the flow.

Another workaround is leveraging an "incremental check" strategy, where a flow runs on a schedule and compares the latest associations with a stored version, triggering only when a new link is detected.