Answered

How to make flow to read data from dynamic excel file

(1) Share

Report

Posted on by 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.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

XRQ57 206 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No
Rkv_ 166 on at

Like (2)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Verified answer

Rkv_ 166 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
XRQ57 206 on at

Like (0)

Report
Copy link

Link copied!

@Rkv_ it is not my topic.
Ask to @Hana123TEI

Was this reply helpful? Yes No
Hana123TEI 49 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yes Thanks it works ...

Was this reply helpful? Yes No