Forum Discussion
Erik Wettergren
Apr 30, 2019Iron Contributor
How to use MS FLow and ODATA to filter a document library on file name?
Hi, I'm trying to filter a SharePoint document library using ODATA in the Get Items action in Flow. I can for example use the ODATA expression startswith(Title,'abc') to make it filter on the Title c...
- 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
Terry_McCullagh
May 01, 2019Brass Contributor
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 Wettergren
May 02, 2019Iron Contributor
By the way, tried to do a similar operation using substringof instead of startswith. Oddly though this didn't work unless I switched places of the FileLeafRef variable and the substring to filter on.