rename file with personalised date in power automate desktop

(1) Share

Report

Posted on by yamina

Hello ,

I want to rename each monday a file like this

Name of the file ; ETATS-GRF-STOCK-HEBDO.CSV

After the last word, I want to insert the date of the file - 7 days

Here the result : ETATS-GRF-STOCK-HEBDO 01-07-2024.csv ( 01 is the day and 07 is the month )

How can I do thas in my flow ?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

eetuRobo 4,583 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

1. Get current date (date only)

2. Format the date to custom date time

3. Use that FormattedDateTime -variable in the new file name just before the file extension (.csv)

Looks like this as a whole:

Was this reply helpful? Yes No
Verified answer

VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @yamina ,

Please find the solution.
Code:
FUNCTION '7Days' GLOBAL DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateOnly CurrentDateTime=> CurrentDateTime DateTime.Add DateTime: CurrentDateTime TimeToAdd: -7 TimeUnit: DateTime.TimeUnit.Days ResultedDate=> ResultedDate Text.SplitText.Split Text: ResultedDate StandardDelimiter: Text.StandardDelimiter.Space DelimiterTimes: 1 Result=> ResultedDate File.RenameFiles.Rename Files: $'''C:\\Users\\Downloads\\mjlangone_0-1719864376475.png''' NewName: $'''ETATS-GRF-STOCK-HEBDO %ResultedDate[0]%.csv''' KeepExtension: True IfFileExists: File.IfExists.Overwrite RenamedFiles=> RenamedFiles END FUNCTION

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
yamina 7 on at

Like
a
(0)

Report
Copy link

Link copied!
Thank you @eetuRobo, your solution helped me but a step was missing.
CurrentDateTime TimeToAdd: -7
so I combine the two answers and here the result

Was this reply helpful? Yes No