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!

View solution in original post

Hi @joew72 ,

 

Thanks for sharing.

 

Best regards,

Sik

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,653)