Answered

[Model driven] Select multiple items from lookup?

(0) Share

Report

Posted on by Naps

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Mira Ghaly 11,415 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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

Publish and save your form

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

Let me know if you need any further help!

Was this reply helpful? Yes No
Naps 55 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No