Forum Discussion

Erik Wettergren's avatar
Erik Wettergren
Iron Contributor
Apr 30, 2019
Solved

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...
Microsoft Flow
sharepoint
  • Terry_McCullagh's avatar
    Terry_McCullagh
    May 01, 2019

    Erik Wettergren 

     

    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

eliotcole-projectfive's avatar
eliotcole-projectfive
Brass Contributor
Oct 15, 2019

Terry_McCullagh ... Nice one, and thanks for the response, I respect that you didn't have to say anything! 🙂

 

I think that the approach that I will take is belt and braces. I'll ensure that I've got a fully annotated (commented) 'Pure Flow Logic' available to the user in what I call 'The Worst Timeline' * so that if it fails, then whomever is managing it can switch to that.

 

Thanks again, mate! 🙂

 

 

* A community reference used to describe a testing branch that I put in most Flows these days via a condition that's always set to run the main line. It'll contain notes, working (how did we get this JSON sample?), and alternates or future parts of the flow, plus some nonsense. Since it's not exactly the easiest place to organise separate Flows (at least, for free users) this feels like the easiest way to ensure that knowledge is available.

zymantas123's avatar
zymantas123
Copper Contributor
Jan 02, 2022
Hello I have a problem with filtering. I used condition attachmentname ends with .pdf but one of three folders still accepts and .png format files. How I can resolve this?

Resources