cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Joshann
Level: Powered On

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
Level: Powered On

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
Level: Powered On

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 Team
Community Support Team

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
Level: Powered On

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

erockafella
Level: Powered On

Re: Search with PowerPoint list

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

Joshann
Level: Powered On

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
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,003)