ODATA Query for Get Files Filename NOT Title

[SylvieLet17]

Hi all, 

I'm trying to filter a library to find a document based on Filename NOT based on Title. 

Our users do not use Titles and asking them to create a name and a title for documents is not a realistic request. 

So, I need to have my Flow check a Library for a specific name. 

I've tried:

Name eq 'value'

FileName eq 'value'

File name eq 'value'

...nothing is working and I can't really find any helpful resources about syntax for document libraries. 

Help?

[v-yamao-msft]

Hi @SylvieLet17,

Do you want to filter out a document based on FileName but not on Tile?

I have made some tests on my side, but with no success.

There are no related docs on this issue could be found.

As a temporary workaround, please use Title instead of FileName. I will keep an eye on this issue and back to you once I have any updates.

Best regards,

Mabel

[SylvieLet17]

Yeah, it looks like Filename is just not available yet.

My process is for a publishing/approval flow. So my workaround was on a previous Flow to set the document title = filename unfortunately. 

Hopefully my users will not require the title for any purposes. 

[v-yamao-msft]

Hi,

Per my certain research and test, I am afraid that filter query based on File name might have not been supported yet.

Please submit a request on Flow Ideas Forum about this issue at here:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Mabel

[Anonymous]

Instead of FileName use FileLeafRef and it works!

[Anonymous]

Thank you! This worked for me