You’re offline. This is a read only version of the page.
Hi folks,
We have a canvas app which has a SharePoint Online list as data source. This list has around 12K items. The below formula is used in power apps for items in gallery with this list:
Share
ReportFilter(SortByColumns(Filter('Consultant Skills',Employee.Email = varColEmployeeEmail && 'Skill Type'.Value = "Primary" ), "Created" , Descending ), Status.Value ="Approved" || Status.Value=Blank() )
All users receive below error when accessing the app:
The app used to work without any issues until last week (app is 2 years old). It used to have around the same number of items at that time as well. Any suggestions to resolve this issue?
@rbn_nue ,
You did not mention the indexed columns (which is almost always the cause of message you are receiving). In your case, you would need to index
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Hi @WarrenBelz
Thank you for the response. The filtered/sorted columns are indexed in SPO. Like I said, the app functioned without any issues until last week.
Hi @rbn_nue ,
You need to index any columns (in SharePoint) that are involved with any of your Filters or Sort functions in Power Apps.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
All responses (
Answers (
143,532
