Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

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

Posted on 25 Nov 2024 16:43:05 by 4
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.
  • Expiscornovus Profile Picture
    Expiscornovus 30,623 on 25 Nov 2024 at 17:01:53
    Get all file names in a sharepoint library that have 'test' in the filename
     
    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))
  • Srini007 Profile Picture
    Srini007 2,747 on 25 Nov 2024 at 16:55:49
    Get all file names in a sharepoint library that have 'test' in the filename
     
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard