cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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

Anonymous
Not applicable

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
v-micsh-msft
Community Support
Community Support

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.
Anonymous
Not applicable

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.

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

Anonymous
Not applicable

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.

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (3,062)