Unanswered

Open a file daily, when the file name changes daily

(0) Share

Report

Posted on by CU25101140-0

I would like to automatically open a csv file in Excel every day and save it as an xlsx file. The problem is that the name of the csv file changes daily (date in the name), so I cannot enter a fixed name when opening the file. Normally this works with the variable *.csv, but Power Automate only displays an error message. What do I have to do?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

It should work with just *.csv in the File filter. What kind of error message it gives you?

You can get the current date and convert that to date to which ever format the filenames date is and then search with that *%FormatDateTime%*. It being inside ** means file name contains

Was this reply helpful? Yes No
Suggested answer

CU25101140-0 2 on at

Like (0)

Report

My flow looks like this (in German):

After starting the flow this error message appears:

Was this reply helpful? Yes No
Suggested answer

eetuRobo 4,204 Super User 2025 Season 2 on at

Like (0)

Report

Launch Excel needs one specific document path. You can't give it folder location and file extension. You need to give it specific file to open. If you think about it if there were more files than just one then how would it know which one to open?

So first get the specific file path with Get files from folder -action. Then use Files[0] to open the first (and only) file in that folder.

Was this reply helpful? Yes No