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 / Search file based on k...
Power Automate
Answered

Search file based on keyword

(1) ShareShare
ReportReport
Posted on by 42

Hello

 

I want to a search a file based on keyword i.e part of the file name

 

there are multiple excel files in one drive folder out of which i want  to copy a specific file based on a keyword. 

I’m using Power automate desktop flow not cloud flow

I have the same question (0)
  • Verified answer
    tkuehara Profile Picture
    667 on at

    Hi @Bk17 

     

    You can filter files in the "Get files in folder" action.

    Example: retrieve all files with the keywork test from a given folder

    tkuehara_0-1626987658095.png

    Variable %Files% result:

    tkuehara_1-1626987737319.png

     

  • Bk17 Profile Picture
    42 on at

    Hi

     

    It works,  can you also show how to open that file using launch excel flow

  • Verified answer
    tkuehara Profile Picture
    667 on at

    Sure!

     

    Here it goes:

    tkuehara_0-1626988269469.png

    %Files% is a list type variable, that's why we need to indicate the index value: %Files[0]%

  • Bk17 Profile Picture
    42 on at

    Thank you 😁😁

  • tkuehara Profile Picture
    667 on at

    My pleasure! 😊

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Is it possible this in the online one but instead of a file looking for a folder

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 801

#2
Valantis Profile Picture

Valantis 602

#3
Haque Profile Picture

Haque 581

Last 30 days Overall leaderboard