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
Solved! Go to Solution.
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!
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!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
187 | |
70 | |
50 | |
37 | |
25 |
User | Count |
---|---|
240 | |
111 | |
91 | |
89 | |
67 |