Unanswered

Get files (properties only) filtering on Name/FileLeafRef not returning values

(0) Share

Report

Posted on by Community Power Pla...

I am currently working on a flow that intends to get items from a data source and then retrieve file properties from a SharePoint library and update them with data from the source.

To do this I am attempting to use the Filter option. The only piece of information that maps to the data source is the 'Name' column in the library which I know is not a 'real' column and should use FileLeafRef instead.

My query in the filter reads : FileLeafRef eq '<value from the datasource>'

The issue I have is that it seems that this does not return any values even though I know the files exist. Its as though the FileLeafRef field isn't pulling back a response.

There was a line of thought whereby maybe the column 'FileLeafRef' wasnt indexed but I was under the impression that this was indexed as standard.

I have been looking at this for a few days now so any assistance would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

eliotcole 4,363 Moderator on at

Like (0)

Report

Is it possible that FileLeafRef isn't a current standard in SharePoint online?

I think it's possibly retired, @Anonymous . Have you tried with either the 'Name' or 'FilenameWithExtension' fields? I have a feeling that 'Name' is now the FileLeafRef ... but I could be wrong there.

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

Like (0)

Report

The reason I tried FileLeafRef was I had tried using the Name and FilenameWithExtension with no success and other posts on forums had suggested the FileLeafRef.
I have even used the GetFiles control without a filter and looked at the output it returns and tried using field names that are in there, but still no joy.

It maybe worth mentioning that the library holds a lot of files, 160k+

Was this reply helpful? Yes No
eliotcole 4,363 Moderator on at

Like (0)

Report

The community will need to see your flow, I think, mate, in order to do anything more for you.

If there's anything private, just obfuscate it.

Also, if possible, edit the screenshots into the initial post, as that will help frame it for anyone that tries to assist.

👍

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

Appreciate the feedback, however I finally resolved the issue.

Turns out it was the size of the library and that the Pagination hadnt enabled. I now get the expected results.

...Panic over.

Was this reply helpful? Yes No
mschwing 14 on at

Like (0)

Report

I am having a similar issue with a flow not returning results using the FileLeafRef. Would you be able to explain the steps you took to turn on pagination?

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

Like (0)

Report

Hi. Did you manage to solve it?

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

Like (0)

Report

.

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

Like (1)

Report

The action "Get files (properties only)" only returns a maximum of 100 entries by default. However, if you expect more than 100 entries, you must activate Pagination. Here you can overwrite the default value to a maximum of 5000. Pagination can be found by clicking on the 3 dots at the top left of the action and then going to Settings.

Was this reply helpful? Yes No