Hello Everyone,
I am trying to design a flow to populate the connecting table that Dataverse creates when you make a N:N relationship.
I am using property address from the Contacts table and property address from the Property table to link them up.
How do I do this? I've done a flow that does a 1:N and that seemed simple enough, but this added complexity is making me stuck.
For reference this was the flow I had for 1:N and it worked great:
Hi @areseia
You can use the related action to add elements to N:N relationships
The first thing you should do is filter the lists based on your need and then use the related action to add the elements from one table to the other
the key is the next step
You must create two table relation actions because you are looking to establish the N:N relationship
Hello!
You need to use the related row action in Dataverse to relate. Here is a M:M example of relationship between system user and role
If my answer helped you, please give me a thumbs up (👍). If solve your question please mark as solution ✔️. This is help the community.
So going forward, should I even bother using the built in feature for Many to Many?
Hi, unfortunately you can't use the connecting table created by dataverse.
You’ll need to create your own custom table to serve as the connecting table.
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1
CU07050602-0
4