cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Naps
Helper I
Helper I

[Model driven] Select multiple items from lookup?

Hi,

This is probably very simple but for whatever reason I cannot figure it out and to be honest I'm getting rather fed up with the way powerapps works. So many things that should be straight forward aren't and the documentation rarely offers any help.

The second to last screenshot is what I want to achieve, selection multiple values from a lookup.
https://www.powercommunity.com/advanced-lookup-experience-in-model-driven-power-apps/

 

Use case:
I have a product table and a parts table. Obviously a single part can be used in multiple products so when creating a new part entry using a form, I want to be able to select multiple products from a lookup field. I tried one to many, many to one and many to many but I'm never allowed to select more than one value from the product table.

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@Naps 

 You should be using N:N relationship between Parts and Products, On you parts form you need to add a subgrid for the products and choose only related records.

Mira_Ghaly_1-1632739940475.png

Publish and save your form

 

Mira_Ghaly_0-1632739796345.png

Click Add Existing Product, you can then select Multiple products and click Add

Mira_Ghaly_4-1632740063774.png

Let me know if you need any further help!

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

2 REPLIES 2
Mira_Ghaly
Dual Super User II
Dual Super User II

@Naps 

 You should be using N:N relationship between Parts and Products, On you parts form you need to add a subgrid for the products and choose only related records.

Mira_Ghaly_1-1632739940475.png

Publish and save your form

 

Mira_Ghaly_0-1632739796345.png

Click Add Existing Product, you can then select Multiple products and click Add

Mira_Ghaly_4-1632740063774.png

Let me know if you need any further help!

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
Naps
Helper I
Helper I

Thanks for your reply. Subgrids indeed work but to be that seems like a rather inefficient way to achieve something rather simple and basic. The subgrid clutters up the interface quite a bit in my opinion.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (5,581)