web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter a SharePoint li...

Power Apps

Answered

Filter a SharePoint list like Search()?

(0) Share

Report

Report

Posted on by BrianHFASPS

732

I have a 2000 item and quickly growing list in SharePoint. Currently I am limiting the return by date with a filter to current school year. Once it is pulled in I use the below to filter by name via a text input box.

Search(
 LocalBehavior, 
 NameSearch.Text,
 "StudentFirst",
 "StudentLast"
 )

I have been asked to allow for historical searches. Ideally this would be completed by filtering the SharePoint list in the same way the Search() does to not need to return the 2000+ records. Is there a way to combine the power of Search and Filter?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Gerard Simpson 2,987 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @BrianHFASPS

If it's just the first and last names you are searching and these are in separate columns, you could use StartsWith on each of the columns, which is fully delegable, so no need to worry about the 2000 datarow limit - sharepoint will serve you as many records back from the result as you need, but the fact that the function is delegable means it will serve them up in an optimised manner of 100 items batches.

The function would be something like:

Filter(

Localbehaviour,

StartsWith(StudentFirst, NameSearch.Text) || StartsWith(StudentLast, NameSearch.Text)

)

Important distinction here is it's a startswith search, not a full contains search - but this shouldn't be an issue in your case as users would be typing from the start of the first/last name, so the approach would be suitable.

Hope this helps

Was this reply helpful? Yes No
BrianHFASPS 732 on at

Like
a
(0)

Report
Copy link

Link copied!
Worked great thanks.
ClearCollect( LocalBehavior, Filter( 'Reports Tracking', StartsWith(StudentFirst, NameSearch.Text) || StartsWith(StudentLast, NameSearch.Text) ) )

Was this reply helpful? Yes No

Join the conversation