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
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gallery is filtered ba...
Power Apps
Answered

Gallery is filtered based on user selection and search needs to be performed

(0) ShareShare
ReportReport
Posted on by shawkinson 76

Hi everyone, 

I have a Gallery that has a list box containing multiple selections - depending on the selection it will take the user to another gallery that is filtered on a different criteria. 

The search function needs to be able to search the selection that is on the screen as well as certain selections from within that search box, however I can not find documentation in regards to this. It also needs to be able to search in i.e. The accounts table which is in this case the account that is attached to the Opportunity - CDS connection

Thanks,

Sigi

Search function.docx
Categories:
Building Power Apps
I have the same question (0)
  • Verified answer
    v-yutliu-msft Profile Picture
    v-yutliu-msft Microsoft Employee on at

    Hi @shawkinson ,

    Do you mean that the gallery will display different table based on the selection of listbox and then the gallery's items will filter based on the text in searchbox?

    If so, I suggest you set the gallery's Items:

    If(IsBlank(searchbox.Text),
     If(listbox1.Selected.Value="....",table1,
     listbox1.Selected.Value="....",table2),
     Filter(If(listbox1.Selected.Value="....",table1,
     listbox1.Selected.Value="....",table2),
     fieldname=searchbox.Text
     )
     )

     

    Best regards,

  • shawkinson Profile Picture
    shawkinson 76 on at

    See attached screen shot - I am having such a hard time with this since it Should do like a Contains find through all entities in the databse - 

    Thanks for all your help

    Sigi

    Search Functions2...

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

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 June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 294 Most Valuable Professional

#2
11manish Profile Picture

11manish 210

#3
Valantis Profile Picture

Valantis 169

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