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?
Michael E. Gernaey
138
Super User 2025 Season 1
David_MA
135
Super User 2025 Season 1
stampcoin
125