Show compatible products with Lookup

(0) Share

Report

Posted on by Frankie70

384

Hi all,

I have a gallery with products (coming from a SharePoint List (Name: ITEquipment) with ID)

I have another list (Name: Related) with columns EquipID (ID of the product) and RelatedID (compatible product (ID of the product)).

When one product is selected I would like to display all compatible products with the help of the "Related" list.

My formula does not work somehow, maybe someone can assist to get it working?

LookUp(Related,Gallery4.Selected.ID=EquipID,LookUp(ITEquipment, ThisItem.RelatedD=ID).Title)

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

Jagadeeshk 457 on at

Like
a
(0)

Report
Copy link

Link copied!

I Understand , you have a gallery which displays item from ITEquipment , and in another gallery you want to display list of related?
if so the second gallery items= lookup(Related, gallery.selected.ID=ID,title)
Frankie70 384 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jagadeeshk
thanks for your reply. This does not work.
The "Related" only has IDs.
In the List ITEquipment, the items have a title with an ID:
So, when selecting an item from the left gallery, I would like to display the related products in the right gallery, with the help of the "Related" list.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Frankie70

You are describing a One to many relationship between Products and Equipment. As such, you would need to use Filter() rather than Lookup(). Lookup will find only the first item while Filter will show all of them.

You could have a dropdown control with the Items property Products and a gallery or datatable with the Items property Filter(Related, RelatedID=Dropdown1.Selected.ID) to show all the related equipment to that product. For some examples of how to design your tables and then show them in PowerApps, check out my blog post here. https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Principles-and-PowerApps-Step-3-Keys-and/ba-p/188640 and the one following it on how to implement it. https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Design-fundamentals-Implementing-a-One-to/ba-p/200521
Jagadeeshk 457 on at

Like
a
(0)

Report
Copy link

Link copied!

Which list you are displaying in left gallery?
Frankie70 384 on at

Like
a
(0)

Report
Copy link

Link copied!

in te left Gallery I have the SharePoint list "ITEquipment"
Verified answer

Jagadeeshk 457 on at

Like
a
(1)

Report
Copy link

Link copied!

Right gallery =filter(Related, EquipID=leftgallery.selected.ID).

Now right gallery shows all items match with ID
Frankie70 384 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jagadeeshk
Great, that did work perfectly. Thank you very much!!
May I ask you one more thing?
I have now two galleries, one on the left with all products and one on the right with related (recommended compatible) products.
I would like the user to be able to click on a recommended product on the right and the gallery on the left will switch to this product then aswell. Any idea how to do that?
Jagadeeshk 457 on at

Like
a
(0)

Report
Copy link

Link copied!

Pls elaborate with steps and screen shots. Or Preferably post a separate query
Frankie70 384 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jagadeeshk
I opened a seperate query here:
https://powerusers.microsoft.com/t5/Building-Power-Apps/Pass-selected-item-from-one-gallery-to-another-gallery/m-p/893596#M283664