Forum Discussion
The requested operation is invalid, the attempted operation is prohibited because it exceeds the lis
We have these 2 SharePoint lists:-
1) Task list with these fields:-
-ID
-Title
2) PeopleWork list with these fields:-
-ID
-Title
-TaskID >> stores the Task's ID in a number field
-People >> is a SharePoint People/Group field which allow single selection
-Status (Active, Closed)
now i built this gallery >> to show the PeopleWork >> which are assigned to the login user + are Active >> so inside the gallery's items property i define this formula:-
Filter( PeopleWork, User().Email = People.Email && Status.Value = "Active")
and i added a field inside the gallery item to show the Title of the related Task as follow:-
First( Filter( task, ID = ThisItem.TaskID)).Title
now one of the users scroll through all the gallery items around 9,000 items >> and after 5 minutes of scrolling >> the user got this error:-
and for now, after 6 hours of getting the above error >> the users is not able to see any item inside the gallery .. the gallery will be shown as white screen without any error or any message.. so what is going on? can i assume that the user met his daily allowed calls to SharePoint,, i hope this is not the case thus... as seems there is a restriction that have been applied to the user account after getting the above error, which is preventing him from seeing any thing inside Power App gallery..
Thanks
- RobElliottSilver Contributor
john john the clue is in your title as you have exceeded the SharePoint list view threshold of 5000 items. That's what's caused your app to stop working. The first thing you should do is to index any column in SharePoint that is being used in your filter. You can read more about this here.
If it was my list I would look to filter the gallery items down further (and perhaps use dropdowns/comboboxes or a search input box to reduce the items in the gallery) as trying to scroll through 9000 items is not a very good user experience.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- john johnSteel Contributor
RobElliottI already added the indexes inside the SharePoint list... also the gallery is designed to show 100 items per time and as you scroll it will show additional items,,, so i can not prevent users from viewing all items if they want
- RobElliottSilver Contributor
john john how are you limiting the gallery to only 100 items at a time? Paginated gallery?
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)