Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Best practice for creating a Many-to-Many table?

Hi all,

I am currently creating an application where I have a gallery of items that has to be able to have one individual item linked to one or more items on a separate gallery of items. 


So in other words, lets say I have Gallery 1, which holds 6 rows of information. I also have Gallery 2, which holds 14 rows of information. I need to be able to go down the list in Gallery 1 and associate each individual line item to a selection of items in Gallery 2. The items in Gallery 2 should be allowed to be repeated for each line item in Gallery 1 as well. 


I am thinking that I need to create a collection that directs both of the galleries, but when I try to create this it does not associate the two sources together as one item in the collection. 


I'm hoping someone has any reccomendations that I can try.

Any help would be greatly appreciated!


Super User
Super User

Re: Best practice for creating a Many-to-Many table?

Hi @swan_soup,

@Meneghinohas an excellent article in his blog on this topic. I think it should answer your questions.  

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,910)