Hello,
I connected a huge database (>20.000 values) via Access to my SharePoint. Now a Workflow should find a variable via "find in list" but gives back value "0".
I cannot shorten the list and I don't want to copy it per hand to the SharePoint.
How can I solve this?
Best answer by Jake
View original
+13
Hi @Sandy2
There is a lookup limit set by the Sharepoint that I believe is 5000 or so depending on your Sharepoint version it could be less.
You either need to index fields on the list and filter your request to below 5000 or loop the request to gather the total amount to keep using a Sharepoint list.
Kind regards
Jake
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
