Forum Discussion

john john's avatar
john john
Steel Contributor
Apr 25, 2022

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

  • RobElliott's avatar
    RobElliott
    Silver 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 john's avatar
      john john
      Steel 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

      • RobElliott's avatar
        RobElliott
        Silver 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)

Resources