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
Responsive Resident
Responsive Resident

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

tkuehara
Responsive Resident
Responsive Resident

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

5 REPLIES 5
tkuehara
Responsive Resident
Responsive Resident

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

Bk17
Frequent Visitor

Hi

 

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

tkuehara
Responsive Resident
Responsive Resident

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

Bk17
Frequent Visitor

Thank you 😁😁

tkuehara
Responsive Resident
Responsive Resident

My pleasure! 😊

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,267)