web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
Register Today: Microsoft Business Applications Update- April 15th
Your Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter Gallery based o...
Power Apps
Answered

Filter Gallery based on dropdown

(0) ShareShare
ReportReport
Posted on by Frankie70 384

Hi all,

I am trying to filter a gallery based on the selection of a dropdown.

Datasource is a SharePoint List.

In the dropdown I choose a Title and based on this selection the Gallery should show only items from another column from that SharePoint List. I want to get the ID of the selected item and then show all other items from the SharePoint list that have the same ID.

I am somehow stuck here...can anybody assist?

Kind regards

FRank

Categories:
Building Power Apps
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 154,930 Most Valuable Professional on at

    Hi @Frankie70 ,

    Firstly, can you please share your code (in Text) you have used and any errors/results of it. As well ID is a unique value in SharePoint, so there are no items with the same ID.

  • Frankie70 Profile Picture
    Frankie70 384 on at

    Hi @WarrenBelz 

    in the Gallery I have to follwing:

    Items: Filter(HubSiteList, DepartmentID = Dropdown1.Selected.DepartmentID).

     

    Frankie70_0-1670217486257.png

    So, I choose a Site (Title) in the dropdown (this site has a DepartmentID and the property isHubsite = true).

    In the gallery I would like to show all sites that have the same DepartmentID but the property isHubsite = false)

     

    Thanks for helping.

     

     

  • WarrenBelz Profile Picture
    WarrenBelz 154,930 Most Valuable Professional on at

    @Frankie70 ,

    Assuming Hubsite is a Boolean (yes/no) column and you want the DepartmentID selected where Hubsite is false

    Filter(
 HubSiteList, 
 DepartmentID = Dropdown1.Selected.DepartmentID &&
 !Hubsite
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

  • Frankie70 Profile Picture
    Frankie70 384 on at

    Hi @WarrenBelz 

     

    this is what I already tried.

    DepartmentID is not accepted for some reason...

    Frankie70_0-1670218617287.png

     

  • WarrenBelz Profile Picture
    WarrenBelz 154,930 Most Valuable Professional on at

    @Frankie70 ,

    That was your code posted initially - I also assume IsHubSite is a Text field ?. What is the Items of Dropdown1 ?

  • Frankie70 Profile Picture
    Frankie70 384 on at

    Hi @WarrenBelz 

    Dropdown1:

    Items = Distinct(Filter(HubSiteList, isHubSite = "true"), Title)

     

    Yes, isHubSite is a Text field.

  • WarrenBelz Profile Picture
    WarrenBelz 154,930 Most Valuable Professional on at

    @Frankie70 ,

    Assuming HubSite is a Text field

    Filter(
 HubSiteList, 
 DepartmentID = Dropdown1.Selected.Result &&
 HubSite = "false"
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

     

  • Frankie70 Profile Picture
    Frankie70 384 on at

    Hi @WarrenBelz 

    but the selected item's DepartmentID must be used for the filter. "Dropdown1.Selected.Result" returns the title.

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 154,930 Most Valuable Professional on at

    @Frankie70 ,

    You have made it difficult for yourself with the Distinct() filter - it needs to be

    With(
 {
 wDept:
 LookUp(
 HubSiteList,
 Title = Dropdown1.Selected.Result 
 ).DepartmentID
 },
 Filter(
 HubSiteList, 
 DepartmentID = wDept && HubSite = "false"
 )
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    Visit my blog Practical Power Apps

  • Frankie70 Profile Picture
    Frankie70 384 on at

    Hi @WarrenBelz 

    that exactly did the trick!!

    Thanks a lot for that!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Register Today: Microsoft Business Applications Update- April 15th
Your Invited to Keeping It Real with the Power Platform

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans