Sharepoint List Input/Output and Over 5000 records

Question

Hello,

I have a flow that uses a SharePoint list connector.  The connector is having issues because the list has over 5000 records.  I have been researching how to solve this issue and have learned that if I create an Azure App, this should solve my issue.  That said, I tried to create the app following a guide from Alteryx.com and was still running into issues.  Has anyone else done this and been successful?

dreldrel · Answer

Maybe try to use the alternative way SharePoint -> OneDrive -> Alteryx to get your data, though this may not be the ideal way

aatalai · Answer

@ScottC1971 have you tried downloading it and reading the file later? I've shared this blog as it might help

minhdvo · Answer

I'm currently using Designer version 2024.1.1.136 Patch 4.

The stored procedure (SP) input is able to load up to 10,000 items. However, even after adjusting the record limit, it still only loads 10,000 items.

I recently modified my SP list to contain 7,000 items. After this change, a new issue appeared: the system continues to load 10,000 items by duplicating entries from the list.