web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Struggling to set the ...
Power Automate
Unanswered

Struggling to set the filter query of my "get files" to be able to give me the links related to the keyword

(0) ShareShare
ReportReport
Posted on by
Categories:
I have the same question (0)
  • Cheese2023 Profile Picture
    on at

    Cheese2023_0-1710345330718.png

     

  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    Try

     

    substringof('The text you are searching for within single quotes',FileLeafRef)

     

     

  • Cheese2023 Profile Picture
    on at

    Cheese2023_0-1710354198521.png

    hey @SudeepGhatakNZ , its still giving me some issues 

  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    See the updated formula above

     

  • Cheese2023 Profile Picture
    on at

    it worked, is there anyway to make spaces between the links? Since it gives me multiple links to the "keyword" 

  • Cheese2023 Profile Picture
    on at

    it didn't work for this input though, could it be because it has DA - in the file name?

     

    Cheese2023_0-1710355036694.png

     

  • Cheese2023 Profile Picture
    on at

    I guess to make it more specific is there anyway filter through the folder and grab the file link instead of the folder that shares the same name as the "keyword"  ? 

  • SudeepGhatakNZ Profile Picture
    14,394 Most Valuable Professional on at

    Is it working for other files? what is the odata filter that gets applied to the action in run mode?

     

  • Cheese2023 Profile Picture
    on at

    for example if I type in Lease Matters, it gives me a bunch of link all connected not being seperated, not allowing me to open the sharepoint link since it's 10 other links combined 

    Cheese2023_0-1710357401821.png

     

     

    @SudeepGhatakNZ 

  • Cheese2023 Profile Picture
    on at

    this happens as well "county property is part of a few files within the SharePoint site but it's not giving me the link 

    Cheese2023_1-1710357528804.png

    @SudeepGhatakNZ 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard