Skip to main content
Community site session details
Power Automate - Building Flows
Answered

Trigger on create N:N Relationship in CDS

Like (0) ShareShare
ReportReport
Posted on 29 Jan 2020 06:07:19 by 24

Hi,

 

We are migrating workflows to flows and the data model is fixed. We have a requirement to trigger a flow when a relationship is established between two entities in a N:N relationship. Since CDS creates a third entity in between to do the mapping, the idea was to take the CDS (current environment) trigger and configure it on the create of the in between mapping entity as "xxx_xxx_entity1_xxx_entity2. We also tried to suffix it with "Set", but the trigger gets corrupted saying the entity is not present in the metadata cache.

 

However, whatever we try, the flow is not getting hit. No run history is present neither. Is this caused because it is an "invisible" entity? Is there a workaround to achieve this? Since it's a migration, there is no possibility to create the "third" entity ourselves.

 

 

  • Verified answer
    yashag2255 Profile Picture
    24,667 Super User 2024 Season 1 on 31 Jul 2020 at 05:32:31
    Re: Trigger on create N:N Relationship in CDS

    Here is one way you can do it: https://www.bythedevs.com/post/trigger-a-flow-when-a-record-is-created-in-an-n-n-relationship-entity-in-cds

     

    Hope this Helps!

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading complete