cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joew72
Advocate I
Advocate I

Display (and Edit) Many-to-Many Relationships in Model-driven App

Hi folks

 

I'm fairly new to to PowerApps and could do with a helping hand. I've tried to find the answer to this question but cannot find it on this community or elsewhere but unless I'm missing something, it seems quite important!

 

I am currently building a Model-driven App for the charity I work for. I have two custom entities - Case and Program. I want a many-to-many relationship between them (as several cases will be taking part in several programs). I've created the many-to-many relationship between these but I now want this to be easy for the user to add, create, manage etc. and the only way I can see them being able to do this is through the Related tab which isn't the easiest UX ever. Is this currently the main way to do this or have I missed something with forms to make it a bit more straightforward?

 

My workaround is to create several lookups on Case to connect them to several programs (which seems nicer for the user) but this seems like a terrible approach to data management so I'd rather avoid this.

 

Any suggestions!

 

Thanks

 

Joe

1 ACCEPTED SOLUTION

Accepted Solutions
joew72
Advocate I
Advocate I

Replying to my own question here in case someone else comes across the problem and is looking for a sort of solution/alternative way of viewing.

 

I discovered that once I have created any relationship (be it 1:N, N:N or N:1), I can then create a subgrid on a form which can then display related information. 

 

So, for the above example, I have created a new tab on the Case file called 'Programs' which then displays all the programs a case is related to. I have also done the same on the Programs tab to display all the cases related to a specific program.

 

Hope this helps anyone one day...and if anyone has any further suggestions, feel free to jump in!

View solution in original post

2 REPLIES 2
joew72
Advocate I
Advocate I

Replying to my own question here in case someone else comes across the problem and is looking for a sort of solution/alternative way of viewing.

 

I discovered that once I have created any relationship (be it 1:N, N:N or N:1), I can then create a subgrid on a form which can then display related information. 

 

So, for the above example, I have created a new tab on the Case file called 'Programs' which then displays all the programs a case is related to. I have also done the same on the Programs tab to display all the cases related to a specific program.

 

Hope this helps anyone one day...and if anyone has any further suggestions, feel free to jump in!

Hi @joew72 ,

 

Thanks for sharing.

 

Best regards,

Sik

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,978)