cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frankie70
Post Patron
Post Patron

Show compatible products with Lookup

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)

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jagadeeshk
Responsive Resident
Responsive Resident

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

 

Now right gallery shows all items match with ID

View solution in original post

9 REPLIES 9
Jagadeeshk
Responsive Resident
Responsive Resident

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)

Hi @Jagadeeshk 

thanks for your reply. This does not work.

The "Related" only has IDs.

Frankie70_0-1618502850022.png

In the List ITEquipment, the items have a title with an ID:

Frankie70_1-1618502911040.png

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 II
Super User II

@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-Pow...  and the one following it on how to implement it. https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-Database-Design-fundamental... 

Jagadeeshk
Responsive Resident
Responsive Resident

Which list you are displaying in left gallery?

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

Jagadeeshk
Responsive Resident
Responsive Resident

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

 

Now right gallery shows all items match with ID

View solution in original post

Frankie70
Post Patron
Post Patron

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
Responsive Resident
Responsive Resident

Pls elaborate with steps and screen shots. Or Preferably post a separate query

Frankie70
Post Patron
Post Patron

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (62,458)