Forum Discussion

john john's avatar
john john
Iron 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...
PowerApps
RobElliott's avatar
RobElliott
Silver Contributor
Apr 25, 2022

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 https://www.c-sharpcorner.com/blogs/if-list-view-threshold-exceeds-then-how-to-handle-it-in-powerapps.

 

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
    Iron Contributor
    Apr 25, 2022

    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
      Apr 25, 2022

      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