Solved

Connected Large Database via Access - Workflow can't find values

  • 6 October 2022
  • 1 reply
  • 1 view

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?



 

icon

Best answer by Jake 14 October 2022, 17:30

View original

1 reply

Userlevel 3
Badge +8

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

Reply