Answered

Powerapps mode driven app buisness process flow many to many relationship

(0) Share

Report

Posted on by Community Power Pla...

Hi, i am having problem with business process flow customization. I have a many to many relationship between two different tables. I am calling the tables as Physicians and Hospitals. I want to assign multiple selected physicians to hospital but the problem is i can only select one physician using lookup field (Please see attached image). How can i assign multiple physicians for the Hospital. I don't have that much experience with Powerapps so i would appreciate the briefed steps. Thanks & Regards

Categories:

Microsoft Dataverse with Power Apps

RapidStartCRM.png

I have the same question (0)

All responses (7)

Answers (1)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

Hi, did you create an M:M relationship in your solution?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Nope, i directly created M:M relationship on Hospital table.

Was this reply helpful? Yes No
Verified answer

Edrei 18 on at

Like (2)

Report

If you created a lookup field on the Hospital Table then you're no longer using the M:M relationship you created. A lookup field is essentially a 1:M relationship(the one side being the table referenced by your lookup in this case Physicians)
To add multiple Physicians to a Hospital, add a subgrid to you Hospital form and select Physicians as the Table

This will allow you to select multiple Physician when you select add Existing from the subgrid.

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

@Edrei did a great job identifying how to fix this...

I would like to suggest something if you may... I usually avoid N:N relationships because it does not allow me to create attributes that define this relationship.

As an example with Physicians and Hospitals you might want to define attributes about this relationship (i.e. dates, role, primary nurse, etc.).

I would normally create a table in-between these two tables and use 1:N relationships in-between. You can then really do a lot more with these and define fields, other relationships from this table etc. Structure would be something like:
Hospital ---1:N---> Hospital Physician <---N:1---Physician

Just thought I would mention this because most times i have ever gone down the N:N path I have switched to this.

Hope this helps. Please accept if answers your question and Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @Edrei , as i said i have very basic experience with powerapps but thanks for your answer you explained it very good. I am having one problem now, i have added the Subgrid and selected the physicians table but i am unable to see Add Existing Physicians or i am unable to see the right side panel in your second screen shot where you are selecting the multiple physicians. Can you please tell me how you are doing this? Please consider my newbie nature while answering my query.

addphysicians.png

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Ok, I resolved it by removing Lookup fields which were creating 1:N relationship. Can somebody tell me now why the Subgrid is not visible to me? i can see the Subgrid in form editor but not visible when i create new Hospital.

No_Subgrid_Visibl...

Subgrid_visible_i...

Was this reply helpful? Yes No
Edrei 18 on at

Like (1)

Report

@Anonymous you have to save the Hospital record first before the subgrid appears; the record doesn't exist yet until that initial save and so there's nothing to relate to, therefore no subgrid

Was this reply helpful? Yes No