Unanswered

Filter a SharePoint List-linked Gallery by different columns depending on whether text is input into particular text input boxes

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all!

I have a Gallery linked to a SharePoint List that has well over 2000 entries. I am assuming traditional Search functionality is out of the picture due to the high number of List items.

What I want to do is create three search bars above the Gallery. Each search bar would filter the gallery by a different column based on the text input. For example, text input into Search Bar 1 searches SP List column 'Title' for what was input. Search Bar 2 searches SP List column 'ID Number'. Etc.

Currently, I tried this but to no avail:

Filter('SP List',StartsWith('Title',TitleSearchBar.Text),StartsWith('ID',IDSearchBar.Text))

Really appreciate any thoughts!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

WarrenBelz 155,540 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

You are correct in that Search is not Delegable and will not work properly on data sets over 2000 records. I have done a blog on Delegation that contains a number of options for large datasets. If any of these suit your model, I am happy to elaborate further.

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.

Was this reply helpful? Yes No
WarrenBelz 155,540 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No