cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

using search function for large data sets

Hi,

 

I am trying to use the search functionality on a large sharepoint data set (170,000 + entries), however delegation is not supported on the search function with sharpoint data sets. I am currently using the Filter function as a work around, but this method is too slow and inconvenient when seaching for something.

 

Current Code: If(Connection.Connected,Filter('Maintenance Applications', StartsWith(Title, TextSearchBox1.Text) || StartsWith(txyv, TextSearchBox1.Text) || StartsWith(pqeh, TextSearchBox1.Text)),Table({Title:" ", pqeh:" ", txyv:" ", sply:" ", vlev:" ", in9s:" ", j2ao:" "}))

 

Is there a work around to have the same functionality as the search function ( ex. when searching for 63481 i get 3-63481-LT43, where as the Filter function would return a blank)?

1 ACCEPTED SOLUTION

Accepted Solutions

I agree you are never going to be happy with a PowerApps app that is using a SharePoint list with 17,000 items. That type of solution is going to be better in CDS or SQL. 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

4 REPLIES 4
Super User II
Super User II

Hi @OPGPowerAPPS,

To get to use the Search functionality, you will need to pare down your list to no greater than 2000 rows using delegatable functions like Filter(), StartsWith() and Sort().  Then create a collection from the resulting list.  You can then use Search on the collection.  As you have discovered, SharePoint is not the best platform for very large lists because of the delegation issues. Sql or Common Data Service will handle them much better.  Of the two, Sql is the most versatile.  For a comparison of the various platforms please see: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list.  If this answers your question, please mark the thread as Solved.

If  possible, use cascading Dropdown boxes to pare down the list to something manageable with Search(). 

I agree you are never going to be happy with a PowerApps app that is using a SharePoint list with 17,000 items. That type of solution is going to be better in CDS or SQL. 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

If i were to use SQL would there be a way to have the SQL server update based on the sharepoint data. I've never used SQL so i am not familiar with how it operates.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (52,537)