Answered

Create new buckets monthly with Month date

(1) Share

Report

Posted on by vel2765

Hello,

I am new to power automate. But I was wondering if there is a way to create a new bucket each month with the specific month as the title?

I have the same question (0)

All responses (16)

Answers (1)

trice602 14,782 Super User 2025 Season 2 on at

Like (0)

Report

Re: Create new buckets monthly with Month date

Hi @vel2765 ,

New bucket in what application, Planner?

Was this reply helpful? Yes No
vel2765 33 on at

Like (1)

Report

Re: Create new buckets monthly with Month date

Sorry, yes in planner.

Was this reply helpful? Yes No
trice602 14,782 Super User 2025 Season 2 on at

Like (0)

Report

Re: Create new buckets monthly with Month date

Hi @vel2765 ,

Perfect. Yes, so you can create a new bucket with a month name. First you will use an expression and get the month name and then use create bucket action.

formatDateTime(body('Current_time'),'MMMM')

Was this reply helpful? Yes No
vel2765 33 on at

Like (1)

Report

Re: Create new buckets monthly with Month date

Thank you so much! This may work. Can I set it up to automatically do it every month on the 30th of each month?

Was this reply helpful? Yes No
Verified answer

trice602 14,782 Super User 2025 Season 2 on at

Like (0)

Report

Re: Create new buckets monthly with Month date

Hi @vel2765 ,

Ok, assuming you want this to run every month, you may want to add the YYYY to the bucket name since once you cycle through, you will get an error. In this new flow, I use Get Future Time and add 2 days to it. I am going to always run at 10:00 on the 30th so will always get the next month.

The month expression is: formatDateTime(body('Get_future_time'),'MMMM')

The year expression is: formatDateTime(body('Get_future_time'),'yyyy')

Next when I create the bucket, I use the output from both compose statements. Please mark as a solution to help others find this answer too!

So when this runs again on October 30th at 10:00, it will create a new bucket named November2023.

Was this reply helpful? Yes No
vel2765 33 on at

Like (1)

Report

Re: Create new buckets monthly with Month date

Thank you! It worked!

Was this reply helpful? Yes No
trice602 14,782 Super User 2025 Season 2 on at

Like (0)

Report

Re: Create new buckets monthly with Month date

Nice! Have a great day over there!

Was this reply helpful? Yes No
vel2765 33 on at

Like (0)

Report

Re: Create new buckets monthly with Month date

Hello, for some reason this isn't working now.. any help?

Was this reply helpful? Yes No
grantjenkins 11,059 Moderator on at

Like (0)

Report

Re: Create new buckets monthly with Month date

@vel2765 Can you explain what's not working now? Is the flow throwing an error, or something else?

Also, I just wanted to mention - you wanted it to run on the 30th of each Month - what about February which only has 28 (or 29 in a leap year) days.

Was this reply helpful? Yes No
vel2765 33 on at

Like (0)

Report

Re: Create new buckets monthly with Month date

The name of the month is not showing up as the title. It is just either gibberish or date and time. I would like the name of the month as the title

Ah! That's true. I really need it to create on the last day of the month for the next month. Or even if it created it at 5 am on the 1st of each month that would be fine too.

Was this reply helpful? Yes No