sharepoint list data over 10000 rows

[JACK_LAI_1117]

HI ALL:

   In power automate , I add sharepoint--get items , then I user filter condition  , beacause my sharepoint list has more than 10000 rows data , so , return error message to me ~~~~~~

   So , how do you to overcome this problem ????

    If I keep my data in azure sql or on-premise sql  , it could filter data over 10000 rows ???

[abm]

Hi @JACK_LAI_1117 

What's the error you are getting? You can retrieve large data set using Power Automate.

Please see below link:

https://alextofan.com/2019/08/22/how-to-get-more-than-5000-item-from-sharepoint-online-in-flow/

Thanks

[JACK_LAI_1117]

@abm 

this is my subscriptions

and this is the error message

So....................... if I have power automate plan1 or plan2  , if my sharepoint list more than 20000 , the filter in powerautomate still work properly .

If it right , I will ask O365 manager team to give me power automate plan1 😊

[abm]

Hi @JACK_LAI_1117 

Could you please the full error message. I can only see it partially from the image your provided.

Thanks

[JACK_LAI_1117]

@abm 

the error mesaage like below 

Body:
{
"error": {
"code": 502,
"source": "flow-apim-msmanaged-na-eastus2-01.azure-apim.net",
"clientRequestId": "a86212a6-7d88-4d43-8fda-2851c0678ed1",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.\r\nclientRequestId: a86212a6-7d88-4d43-8fda-2851c0678ed1\r\nserviceRequestId: 5631839f-9045-b000-5c0c-6a90cca461e1",
"source": "https://XXXX.sharepoint.com/sites/XXXXX/_api/web/lists/GetByTitle('XXXXXXX')/items?$filter=asset_x00...'",
"errors": [
"-2147024860",
"Microsoft.SharePoint.SPQueryThrottledException"
]
}
}
}

Headers:

{
"Pragma": "no-cache",
"x-ms-request-id": "5631839f-9045-b000-5c0c-6a90cca461e1",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"Cache-Control": "no-store, no-cache",
"Date": "Tue, 13 Oct 2020 07:41:52 GMT",
"Set-Cookie": "ARRAffinity=fa9050a86380ecce883d8ff2e805dd22d58cc29332b6761a0fc08c7d82b3fa74;Path=/;HttpOnly;Domain=sharepointonline-ncus.azconn-ncus.p.azurewebsites.net",
"Content-Length": "822",
"Content-Type": "application/json",
"Expires": "-1"
}

[abm · Accepted solution]

Hi @JACK_LAI_1117 

Thanks for the reply. This is not related to license hence I asked the detailed message. There is a threshold view limit set in your SharePoint.

Please have a look at

https://www.ohthreesixtyfive.org/2018/03/microsoft-flow-overcoming-the-list-view-threshold.html

Thanks

[JACK_LAI_1117]

@abm 

Yes , I flow your method to create index in my sharepoint list . Now I can filter data in over 10000 rows sharepoint list .

And I need to create 4~6 indexes , so it will cause other problem ??? 

[abm]

Hi @JACK_LAI_1117 

Thanks for your reply. If you hit the same error then you may need to do the same.

Thanks