Forum Discussion
How to use MS FLow and ODATA to filter a document library on file name?
- May 01, 2019
Erik,
Instead of using name as the filter, try FileLeafRef -
I was able to return all files from this library whose names start with the letter H.
Hope this helps.
Terry McCullagh
Erik,
Instead of using name as the filter, try FileLeafRef -
I was able to return all files from this library whose names start with the letter H.
Hope this helps.
Terry McCullagh
It certainly helps!
Just out of curiosity - how did you figure this one out? From the SharePoint Search Schema?
Thank you!
- Terry_McCullaghMay 02, 2019Brass Contributor
Erik,
I've found the Odata Query Builder from Authur Graus to be extremely helpful in constructing the correct queries.
https://appsource.microsoft.com/en-us/product/office/WA104051159
This article is also helpful:
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests
Regards,
Terry
- Erik WettergrenMay 06, 2019Iron ContributorHi and thanks again! Great tip about the Query Builder and a useful article.
/Erik- Terry_McCullaghMay 08, 2019Brass ContributorErik - Glad to have been of assistance.