Sharepoint List Input/Output and Over 5000 records

[ScottC1971]

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?  

[TimothyH]

Hi @ScottC1971  Have you tried the newest version of the connector 2.7.2.  That limitation was addressed in that version

[BonusCup]

@ScottC1971 and/or @TimothyH 

I'm on Designer version 2023.1 patch 9 and I was having the same issue as @ScottC1971.  I downloaded and installed the new SP connector version 2.7.3.  I'm no longer getting the error but it doesn't seem to be bringing in all the records.

The SP list has a total of 6,372 records but Alteryx is only pulling in 3,162 records.  

[minhdvo]

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.

[aatalai]

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