When I run the SharePoint Input for a list I got an error 'list object has no attribute columns'. The tool works for one list, but not the other. The one that does not work has 50K records. Is there a limit to this tool and if so is there a workaround?
Hi @BMaisel! Were you able to solve this? I came across this Knowledge Base article that may answer your question. And based on this thread, it seems like there is a limit of 5k records.
Hope that helps!
Flávia
I've been able to overcome the limit by using a macro that uses the REST API, it basically batches the results per page then gives me one output.
You can setup a python code that will fetch this list for you. It has worked for me in past, and its fast enough when running on gallery.
User | Count |
---|---|
109 | |
89 | |
77 | |
54 | |
40 |