cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hana123TEI
Helper I
Helper I

How to make flow to read data from dynamic excel file

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.

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Rkv_
Resolver II
Resolver II

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

View solution in original post

6 REPLIES 6
XRQ57
Resolver I
Resolver I

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
Super User
Super User

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

 

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

Rkv_
Resolver II
Resolver II

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

Rkv__0-1643956063960.png

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

Rkv__1-1643956159006.png

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





Rkv_
Resolver II
Resolver II

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

XRQ57
Resolver I
Resolver I

@Rkv_ it is not my topic.

Ask to @Hana123TEI 

Hi, 

 

Yes Thanks it works ...

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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

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 (2,524)