web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter a gallery based...

Power Apps

Answered

Filter a gallery based on a different list

(0) Share

Report

Report

Posted on by L0n35

I have a Gallery called AccommodationGallery. This contains data from my Accommodation list which stores accommodation information. For example: [1, The Microsoft Hotel, PowerApps Street, 1234 5678].

I want to filter this gallery based on another list called Accommodation Categories. This list stores the accommodation ID and a single category for that accommodation as they can have multiple categories. For example: [1, Budget], [1, Metro], [1, Pets].

How can I filter the Accommodation gallery based on one or more selected category types?

Any help would be greatly appreciated.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

BJ94 264 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @L0n35

https://powerusers.microsoft.com/t5/Building-Power-Apps/SharePoint-form-filtering-dropdown-based-on-data-from-different/m-p/890213

This link is useful for you. It will solved your problem.

-------------------------------------------------------------------------------------------
Regards,
Bharti
Community Support Team _ Bharti
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @L0n35,

Could you please tell me that if the ID column is the sharing column between the two lists?

Do you have a dropdown control like Combo Box to display categories?

If so, I think you could set the Items property of the AccommodationGallery as below:

Filter(Accommodation,Projects in Filter(AccommodationCategories,Category in ComboBox4_1.SelectedItems.Result).Project)

Note that I set the Combo Box items property using the Distinct() function.

Join the conversation