Unanswered

Get files with Odata filter on name

(1) Share

Report

Posted on by MrMarshall

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?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

MattWeston365 1,701 on at

Like (17)

Report

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.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (1)

Report

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,

Was this reply helpful? Yes No
arctirux 4 on at

Like (0)

Report

Hi,
You can use Title eq '' .

I hope that helps.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (7)

Report

FileLeafRef works for me:

Was this reply helpful? Yes No
Muktatt 7 on at

Like (0)

Report

This solution worked like a charm. Thanks for the solution

Was this reply helpful? Yes No