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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Combo box filter of ga...
Power Apps
Answered

Combo box filter of gallery working if scroll and click but not if search and click

(0) ShareShare
ReportReport
Posted on by 10

Hi,

 

I'm having an issue and struggling to work out what is going on.

 

I have a SharePoint list with a choice column, this column does have 204 options, I thought this might potentially be important.

 

I've created a filtered gallery on the combo box (amongst other things). 

 

The gallery filters correctly on the combo box if I scroll the list manually and click on options, however if I type a search term and click on the search result options it does not filter.

 

Have I hit a limit of some sort, or potentially doing something wrong?

 

The code is quite large so won't post initially but can do if required.

 

Thanks!

Categories:
I have the same question (0)
  • Verified answer
    Samuel-Zhou Profile Picture
    393 on at

    @elganmas I think your filter formula needs to include the search conditions of the combo box

    you can try 

    Filter(
     YourDataSource,
     YourCondition,
     ComboBox.Selected.Value = Blank() Or 
     column.Value = ComboBox.SearchText Or 
     column.Value = ComboBox.Selected.Value
    )
  • elganmas Profile Picture
    10 on at

    Thanks for the reply, I tried adding the .SearchText option but it was erroring saying text cannot be used in this way.

     

    However your use of column.value made me look at the rest of my code. I hadn't added .value before.

     

    Adding the .value now gives me my expected result so thanks!

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 392 Most Valuable Professional

#2
11manish Profile Picture

11manish 136 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 109 Super User 2026 Season 2

Last 30 days Overall leaderboard