Unanswered

Model Driven App - Bulk edit Many to Many

(0) Share

Report

Posted on by schdaef

Hi Community!

I have a model driven app with two tables only. There is a many-to-many relationship between these tables, and I am looking for an efficient way to associate / disassociate records from Table A to Table B.

Currently I do have a simple form created for Table A with a sub grid showing Table B – this of course only allows to edit one record at a time. My dream state is that select several records in Table A and link these with just a few clicks to a selection or all records from Table B.

I know that there is a XRM Toolbox add-in allowing to do this, but I want to deliver this piece of functionality directly for the users in my model driven app. Anyone able to provide some directions? Thanks very much!!

Best regards,

Stefan

Categories:

Microsoft Dataverse

All responses (8)

Answers (0)

SvenD09 2 on at

Like (0)

Report

Re: Model Driven App - Bulk edit Many to Many

Did you find a solution? I face the same requirement.
Odidepse 16 on at

Like (0)

Report

Re: Model Driven App - Bulk edit Many to Many

Did you manage to come up with bulk edits on many to many scenario? Cheers
Drew Poggemann 9,278 Most Valuable Professional on at

Like (0)

Report

Re: Model Driven App - Bulk edit Many to Many

Hi @stef2

Sorry, you are right, it is still a "select one Record A" and it provides a quicker way to select multiple of Record B.

This would need to be something custom either through PCF or through an embedded Canvas App...

Thanks,

Drew
schdaef 7 on at

Like (0)

Report

Re: Model Driven App - Bulk edit Many to Many

Hi Drew! Thanks for your response - an interesting control, but I am struggling to understand how it could solve my problem of selecting several records in Table A and assign several records from Table B in one bulk operation. Am I missing something?

Thxs,
Stefan
Drew Poggemann 9,278 Most Valuable Professional on at

Like (1)

Report

Re: Model Driven App - Bulk edit Many to Many

Hi @stef2 ,

Check out the following PCF control which might come in handy here...
https://pcf.gallery/nndropdown/

Hope this helps. Please accept if answers your question or Like if helps in some way.

Thanks,

Drew
cchannon 4,702 Super User 2025 Season 1 on at

Like (1)

Report

Re: Model Driven App - Bulk edit Many to Many

Yeah, there is really no OOB mechanism for doing this, you would need to build your own UI for it. You could do that in a PCF by building a dataset control that uses fluent UI details lists to put the two sets of records side-by-side for selecting and linking.
schdaef 7 on at

Like (0)

Report

Re: Model Driven App - Bulk edit Many to Many

Thxs! I am aware of the basic features you get with N:N relationships and subgrids, but what I was asking for is beyond that. Here is a pic that helps explain again in more details:

-> I want to select several records in Table A and assign several records from Table B in one operation.

Hope this is clearer now? Any advice on that?

Thanks much againg!!
cchannon 4,702 Super User 2025 Season 1 on at

Like (0)

Report
Re: Model Driven App - Bulk edit Many to Many

This is already a capability for N:N relationship subgrids:
From the subgrid, you can select multiple rows and click Remove to remove them all at once
(again from the subgrid) In the panel opened by the Add Existing button, you can select multiple rows and click Add to add them all.