How to make flow to read data from dynamic excel file

[Hana123TEI]

I am creating a flow where in a folder different Excel files are there , but I want to say open only Particular excel file 

whose name is dynamic at the end date is written. 

Lets say in folder 3 files Book1, book 2 and Category20120221 I have to read data from Category file which will be replaced every month as Category20120321 and from this Category file data need to read .

How is possible this in Power automate.

[XRQ57]

Hi

If the stream only needs to read a specific file, I don't think Power Automate is the best solution.
Personally, I would go through PowerQuery.
As soon as the file contains the word "Category", it will load the data into a table which can be used on PAD.

[MichaelAnnis]

Get files Category*.xlsx to %Files% (click on Advanced) Sort by Last Modified descending.

The latest file will always be %Files[0]%

[Rkv_]

@XRQ57 You can directly use Launch Excel action, and specify variables in Document Path.

In the above screenshot  the variable %SpecialFolderPath%  is path to Documents folder.
and the variable %FormattedDateTime% is the date in required format.

So the above program will launch excel file with name Category20220204.xlsx under My Documents folder.  
I hope the above helps you.

[Rkv_ · Accepted solution]

@XRQ57 if the above solution is useful to you, Please mark it as a solution.

[XRQ57]

@Rkv_ it is not my topic.

Ask to @Hana123TEI 

[Hana123TEI]

Hi, 

Yes Thanks it works ...