Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Get files with Odata filter on name

I am trying to get files in a document library witha filter on Name, not Title.

I do understand the difference between column Name and Title in a Sharepoint library, but the customer is not using Title field.


Running the action Get files (properties only) with the Odata query "Name eq 'TestName'" returns an error saying that the column Name does not exists.


Have anyone succedded with running the action "Get Files (properties only)" with a simple filter on the default Name column in a Sharepoint library?





Hi @MrMarshall when you get under the covers of SharePoint, Name doesn't actually exist as a column within the library. It is actually something which is calculated which is why it is surrounded by { } when you look at the output without a filter applied.


The best field to try and filter your query on is "FileLeafRef" which contains the full filename e.g. MattWeston365.docx


So if you query based on that column with the full document name then you will retrieve the item you want back.

Did my reply help? Please give it a thumbs up.
Did I answer your question? Please mark my post as a solution!
If you liked my response, please consider giving it a thumbs up. THANKS!

Proud to be a Flownaut!

Community Leader: Black Country PowerApps & Flow User Group

Community Support
Community Support

Hi @MrMarshall ,


As @MattWeston365 described, Name field is actually wrapped in {} with the field name, so it cannot be applied to Filter Query.


Please consider using Condition or Filter array to filter the items.

Image reference:


Please take a try.


Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Frequent Visitor


You can use Title eq '' .














I hope that helps.

FileLeafRef works for me:


This solution worked like a charm. Thanks for the solution

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,140)