cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Joshann Helper II
Helper II

Search with SharePoint list

I am building a PowerApp that has a SharePoint list with 14,000+ records in it as its data source.  I need my users to be able to search for a text string within a field.  However, the Search function is not delegable with SharePoint, so it only searches the first 500 records if I use the Search function.  The StartsWith function is delegable, but as I said, I need my users to be able to search for a text string within a field, not for a field that starts with the text string.

 

Being able to search records is such a common task, that I am thinking there must be some sort of workaround for this problem.  Can anyone help me?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Joshann Helper II
Helper II

Re: Search with PowerPoint list

Thank you for your reply.  Since I posted this question, I figured out how to do what I needed.  Soon I will post what I did so others might benefit from it.

View solution in original post

Joshann Helper II
Helper II

Re: Search with PowerPoint list

Unfortunately, it turned out that I was wrong.  There is currently no way to search a SharePoint list that has more than 5,000 records for a text string contained in a field usig PowerApps.

View solution in original post

4 REPLIES 4
Community Support
Community Support

Re: Search with PowerPoint list

Workaround should be:

1. Cache the SharePoint list in collection within PowerApps,

2. Consider take use of Sort () and filter together.

 

Adding the delegation for reference:

Delegable data sources

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Joshann Helper II
Helper II

Re: Search with PowerPoint list

Thank you for your reply.  Since I posted this question, I figured out how to do what I needed.  Soon I will post what I did so others might benefit from it.

View solution in original post

Highlighted
erockafella Advocate I
Advocate I

Re: Search with PowerPoint list

@Joshann do you mind posting what you have done to resolve this concern?

Joshann Helper II
Helper II

Re: Search with PowerPoint list

Unfortunately, it turned out that I was wrong.  There is currently no way to search a SharePoint list that has more than 5,000 records for a text string contained in a field usig PowerApps.

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (9,450)