Error inside our Edit form on a SharePoint lookup field "The attempted operation is prohibited because it exceeds the list view threshold."

(0) Share

Report

Posted on by johnjohn123

3,514

We have 2 SharePoint lists:-

1) Projects

2) Tasks. The Tasks list has a SharePoint lookup field which reference the Projects list, as follow:-

now the Project list has around 11,000 items >> and when we added an Edit form for the Tasks list inside Power Apps canvas app we got this error on the Project lookup field:-

so is there a way to overcome this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

Make sure you have some indexed columns and I think that all you need to do is make sure that this column is one of those indexed ones?

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@EddieE yes we already defined indexes for the columns. where we defined an Index on the Project lookup field inside the Tasks list as follow:-

and also we index the Title field inside the Projects list, as follow:-

but still we are getting the error.. any advice?

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

Yeah ok, I thought that may not work tbh. I've used that technique for Text / Numeric columns before and it does work - just wasn't sure about LookUp columns because I avoid them in my PowerApps. They are too problematic.

Here are a few forum links that may help you out? The first one seems to provide a solution but I cannot test because I don't have a large enough list to test on. The other 2 (slightly older) suggest that the only way to solve this is to create Text/Numeric helper columns and use these in your filtering.

1. https://powerusers.microsoft.com/t5/Building-Power-Apps/Sharepoint-List-View-Threshold-affecting-Power-App-Lookup-column/td-p/1798442

2. https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApp-SharePoint-Lookup-Column-Threshold-Limit/td-p/791642

3. https://powerusers.microsoft.com/t5/Building-Power-Apps/Lookup-column-threshold-affecting-power-app/td-p/681202

Sorry I couldn't be of anymore help.

Was this reply helpful? Yes No