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 with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

cchannon 4,702 Moderator on at

Like (0)

Report
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.

Was this reply helpful? Yes No
schdaef 7 on at

Like (0)

Report

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!!

Was this reply helpful? Yes No
cchannon 4,702 Moderator on at

Like (1)

Report

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.

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

Like (1)

Report

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

Was this reply helpful? Yes No
schdaef 7 on at

Like (0)

Report

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

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

Like (0)

Report

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

Was this reply helpful? Yes No
Odidepse 16 on at

Like (0)

Report

Did you manage to come up with bulk edits on many to many scenario? Cheers

Was this reply helpful? Yes No
SvenD09 2 on at

Like (0)

Report

Did you find a solution? I face the same requirement.

Was this reply helpful? Yes No