Get Files filtering by file name using ODATA query fails with FileLeafRef fails for some files (not all)

(0) Share

Report

Posted on by Sam4

229

Hi,

I'm having an issue that I am not able to solve. Will appreciate any help on this matter.

I have a SharePoint List with a list of files and Owners. I also have a SharePoint Library with the files.

I want to assign the owners to the SharePoint Library too. The SharePoint List is something like that:

Files_Index

File 1 - Owner A

File 2 - Owner B

File 3 - Owner A

As a summary my flow is doing the following:

Get Items (from Files_Index)
Apply to Each
Get files (properties only)
1. Filter Query: FileLeafRef eq 'AttachmentFileName'
Update file properties

That works for the most of files but not for all of them. I've made some test running the flow individually for each file, and same flow works fine with File 1, File 2, but not with file 3.

The expression "FileLeafRef eq 'File 3'" is not valid. Creating query failed. clientRequestId: xxxxxx. serviceRequestId: xxxxxxxxxxxx

It seems it can't create the query for some reason, but I've checked the file name in the library and in the list and it matches. so not really sure what is happening.

Any help will be much appreciated.

Kind Regards

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Sam4 ,

Could you share the full screenshot of the flow configuration so that we could check the error easily?

@Sam4 wrote:
I have a SharePoint List with a list of files and Owners.

Do you mean that the file is stored in the attachment of the item?

Best Regards,

Was this reply helpful? Yes No
Verified answer

Sam4 229 on at

Like (1)

Report
Copy link

Link copied!

Hi @v-bacao-msft thanks for your reply.

The files are stored in the Library, the list only has two text columns: filename and owner. I wanted to add the column owner to actual file in the library.

However I found the issues that I had and this has already been sorted. Just giving the explanation below if someone has a similar problem.

My two issues were I had some characters in the filenames as <<'>> and <<&>> that were impacting in the filter. So the ODATA query FileLeafRef eq 'Attachmentfilename' was not working when the filename was something like "James' Exam 1 & 2.pdf".

The other issue was simpler. I had more than 5000 files in the library so it was only taking the first 5000 items. It seemed to me that despite you have a filter query it is only considering the first 5000 items so I moved the excess (there were a few only) to a different library.

Hoe this can help to someone.

Kind Regards

Was this reply helpful? Yes No
Sunshine14 11 on at

Like (0)

Report
Copy link

Link copied!

Dear All,
I have used get files( properties only) filter query to get attachments but I can only retrieve one attachment. I want to be able to get all attachments with the unique number whether it is in .txt, .pdf, .doc. When I run the filter query individually for these, it works fine but I am not able to get all the attachments with the unique number (with different document format) to be emailed in the next step. Please help

Was this reply helpful? Yes No