Unanswered

Get all file names in a sharepoint library that have 'test' in the filename

(0) Share

Report

Posted on by GS-21112109-0

I'm struggling to find the right action to get a list exported to pdf or xls of all files in a share point library that have the work 'test' in the filename. I'm using Get Files (Properties only), but don't seem to have the query right.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Srini007 3,327 Super User 2025 Season 2 on at

Like (0)

Report
Hi @GS-21112109-0,

Are you facing any issue, check below for few steps,

Use Get Files(properties only) Action

Use Filter Array action and in that write condition as contains(item()?['Name'], 'test')

This way you can filter all the file name which contains test in it

If I have answered your question, please mark it as the Answered. If you like my response, please give it a Like.

Regards,
Srini

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @GS-21112109-0,

Try to combine the substringof with the FileLeafRef property in the Filter Query.

Below is an example

I have also added the FSObjType eq 0 as an additional filter to only retrieve files, because normally the action also returns folders.

(FSObjType eq 0) and (substringof('Test', FileLeafRef))

Was this reply helpful? Yes No