web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to Trigger a Power...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on 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
Categories:
I have the same question (0)
  • Infamous_Let Profile Picture
    330 on at
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard