Search file based on keyword

[Bk17]

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

[tkuehara · Accepted solution]

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

Variable %Files% result:

[Bk17]

Hi

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

[tkuehara · Accepted solution]

Sure!

Here it goes:

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

[Bk17]

Thank you 😁😁

[tkuehara]

My pleasure! 😊

[Raul]

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