cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bk17
Frequent Visitor

Search file based on keyword

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
tkuehara
Super User
Super User

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

 

View solution in original post

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]%

View solution in original post

6 REPLIES 6
tkuehara
Super User
Super User

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
Frequent Visitor

Hi

 

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

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
Frequent Visitor

Thank you 😁😁

My pleasure! 😊

Raul
Frequent Visitor

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,284)