Unanswered

Power Apps showing list view threshold error even with filter

(0) Share

Report

Posted on by rbn_nue

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:

Filter(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?

Categories:

Using Apps Using Formulas

Connectors

Connecting to Data

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 151,875 Most Valuable Professional on at

Like (0)

Report

Re: Power Apps showing list view threshold error even with filter

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

Was this reply helpful? Yes No
rbn_nue on at

Like (0)

Report

Re: Power Apps showing list view threshold error even with filter

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.

Was this reply helpful? Yes No
WarrenBelz 151,875 Most Valuable Professional on at

Like (1)

Report
Re: Power Apps showing list view threshold error even with filter

@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

Employee.

'Skill Type'.

Created

Status

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

Was this reply helpful? Yes No