You’re offline. This is a read only version of the page.
Announcements
4
Built a flow to bulk populate a SP List (after querying a library)
I pull all the documents with URLs where filename starts with "BMP_"
Then it checks folder it is in is called "Current".
Then creates a list item with a link to open the file.
All works great.
But only returns 100 items by default when I use a Filter Query (ODATA) in my Get file (properties only)
startswith(FileLeafRef, 'BMP_')
It seems with a Filter Query I cannot get more than 100 items!
If I remove the Filter Query and enable pagination (set to 10k) I get all 10000 items!
BUT if I set it to 35000 items I hit this error/limit of data in SharePoint The action 'Get_files_(properties_only)' has an aggregated page results size of more than '209915130' bytes. This exceeded the maximum size '209715200' bytes allowed.
Here is the setup..
Setup below
Whether I adjust Top Count/Pagination it always returns 100 like below
If I remove the Filter Query I can get lots of items (until I hit the query limit of data), I got 10000 below when I set the Pagination to 10k (but 35k it failed), there are 35000 documents in this library!
I want to pull all the document URLs that start with "BMP_"
Can you not query more than 100 library URLs with Get files AND using a Filter Query?
Should I instead do this usingthe REST API/HTTP Request?
Kind Regards,
Paul
Share
Report
All responses (
Answers (
