Skip to main content

Notifications

Community site session details

Community site session details

Session Id : RJ8PoXRq6Km5KvcbUf6R4T
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 17 Feb 2025 14:07:58 by

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
  • Infamous_Let Profile Picture
    155 on 17 Feb 2025 at 14:21:09
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 138 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 135 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 125

Overall leaderboard
Loading started