Answered

Renaming Files by Quarter

(0) Share

Report

Posted on by Tomiy

I want to rename files by quarter for example "2024.Q1 Combined Financials" using Power Automate Desktop. I am not able to rename by quarter in this way, only 2024.06.04 for the current date. Is there a way to include the quarter when naming the files?

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Tomiy

There isn't a direct date format for quarters. You can indeed use the "MM" format to get the month and then map the month to the corresponding quarter using a variable.

Was this reply helpful? Yes No
Tomiy 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your very timely response. Do you know how to map the month "MM" to a variable that will change as the date also changes? For example, if MM returns a value of 1, 2, or 3, I want it to read "Q1". 4, 5, and 6 would read "Q2". I appreciate your assistance.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hope this helps @Tomiy

Was this reply helpful? Yes No
Tomiy 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, @SudeepGhatakNZ, your input is appreciated. Do you know how to do add "and" statement within the if conditional? I am able to write the first part, but I cannot find a way to add an "and" to the function for Q1. I am going to repeat this for the other quarters as well. I attached a screenshot of my flow for renaming the quarters by date.

Was this reply helpful? Yes No
Tomiy 43 on at

Like
a
(0)

Report
Copy link

Link copied!

I used the following syntax for the AND statement. I think this works.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, that is correct.

Was this reply helpful? Yes No