Unanswered

Many to Many - Select Multiple Lookup Items in Combobox

(0) Share

Report

Posted on by MechEng2013

257

Hello, I'm trying to learn and understand the many to many function as I am trying to use a combobox to select multiple lookup records from a second table and save those multiple entries to my lookup column.

Maybe this can't be done this way and maybe there is a workaround that I can do?

Essentially I have a table that tracks project information, and I have other tables that are for Samples and Quotes. I want to be able to relate multiple Samples and multiple Quotes to one Project. Then when I am in my Project, be able to click a Listbox or Gallery of those Samples/Quotes which will take me to the Samples/Quotes Form screen (I already achieved this with a Listbox with the single-selection of Sample/Quote).

picture of my current boxes (after I save the form, it only saves the first selection)

Is there a way to do this with the lookup column, or will I have to do a workaround, for example concatenating the IDs into a text column, and then performing lookups to those ID's to get the functionality I want?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-hanytian-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MechEng2013 ,

May I Ask what data source you have used?
Let us assume that is SharePoint.

We made a Sample for you.
OnChange of DataCardValue:
ClearCollect(Col1,DataCardValue2.SelectedItems.Id)

Update of DataCard:
Col1

Insert a Button for Submit a form.

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
MechEng2013 257 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually, I'm using Dataverse. Does that change much? I'm not familiar with Sharepoint lists...
Thanks

Was this reply helpful? Yes No
MechEng2013 257 on at

Like
a
(0)

Report
Copy link

Link copied!

I have tested this, as I said I'm using Dataverse, and it does not work. Update field of DataCard returns error: "Expecting Record Value" - Col1 returns a table.

Was this reply helpful? Yes No
MechEng2013 257 on at

Like
a
(0)

Report
Copy link

Link copied!

Update to where I'm at now. I've researched the world of Many to Many relationships and have found good information out there. I'm having trouble getting my app to work as examples are shown however and I might be trying to do too much. Basically I want to be able to edit these relationships while in an Edit Form, and maybe that's not possible. I also have to lookup the record that I'm currently selecting (I use a variable to store the record) in order for the change in relationship to show in the new gallery.

I have tried showing the relationships in a gallery, in a listbox, and in a datatable. Reasons were that I was trying to put it into my edit form inside of a datacard. Gallery is the only one that seems to work OK, but I might just need to put it on a separate screen to do that - which I am OK with, but I still want to be able to at least display the relations in my form. Listbox seems to work, except it does not show the text labels of the records!! ugh

Was this reply helpful? Yes No