Suggestions for SharePoint delegation issues?
Looking for feedback on a Power App that will connect to a SharePoint list that could grow above 10,000 records. I found out the hard way that a ClearCollect combined with DropColumns was a no-go for a big list in SharePoint. The hard way, naturally, once it was already in production. "Why was this working and now it's not??!!" (sigh). 🤦🏻♂️ I changed the code from this: ClearCollect( colMyLinks, Sort( Filter( DropColumns('My Quick Links', "{VersionNumber}", "Modified"), 'Created By'.Email=gblUserProfile.mail), SOrder ) ) To this: ClearCollect( colMyLinks, Sort( Filter('My Quick Links', 'Created By'.Email=gblUserProfile.mail), SOrder ) ); ClearCollect( colMyLinks, DropColumns(colMyLinks, "{VersionNumber}", "Modified" ) ) I know, I know - converting to dataverse would likely make for a better solution. But will I hit any issues with the new approach? It seems to be working. The collection getting pulled in is only about 10-20 rows from the SharePoint list, so the app itself doesn't need to work with very much data. I figured the collection approach would be efficient. But obviously it comes with issues of it's own.