at the beginning of the month create Sharepoint folders for specific days of the next month

[pasquale_p]

Hi all, 

I'm trying to create a flows where at the beginning of each month create the folders named as each MON, TUE, WED, FRI of the next month

e.g. 

we're on 01st June, the flow have to create folders named for 

mon 03.july.2023

tue 04.july.2023

wed 06.july.2023

fri 07.july.2023

mon 10.july.2023

tue 11.july.2023

wed 12.july.2023

fri 14.july.2023

mon 17.july.2023

tue 18.july.2023

wed 19.july.2023

fri 21.july.2023

mon 24.july.2023

tue 25.july.2023

wed 26.july.2023

fri 28.july.2023

mon 31.july.2023

same of august and so on

thanks in advance for your support,

cheers

[David_MA]

The attached flow should get you started on what you need. In the Do until action, replace the Append to array variable Dates action with the action to create a folder. Although you may want to keep the Append to array because once the entire array is created for the year, you can then filter it for the current month and use those values to create your folders.

I've set it to it creates the dates in the format you are looking for:

This will do it for the entire year specified and takes into account whether it is a leap year for the month of February. You'll need to figure out how to modify it to run monthly and get what you need unless you're happy with it creating all the folders in one shot.

[ManishSolanki · Accepted solution]

Hi @pasquale_p 

Here is the flow which will be helpful in your scenario:

1. Set up the recurrence to flow to run on 1st of every month:

2. Next, Initialize variables to hold the start date of next month & days in that month:

Expression used to get the next month start date is:

startOfMonth(addDays(utcNow(),32),'yyyy-MM-dd')

Expression used for varEndCounter:

int(addDays(startOfMonth(addDays(utcNow(),64)),-1,'dd'))

4. Next, we will increment the start date to last day of the month. In between, we will check if the day is weekday, if found then create a folder in SharePoint:

Inside do while action, check the condition for weekday:

Expression used for checking weekday is, used for both condtions:

dayOfWeek(addDays(formatDateTime(variables('varNextMonthStartDate'),'yyyy-MM-dd'),variables('varStartCounter')))

If weekday then create a folder:

Expression used for folder path:

formatDateTime(addDays(formatDateTime(variables('varNextMonthStartDate'),'yyyy-MM-dd'),variables('varStartCounter')),'ddd dd.MMM.yyyy')

After Condition action, increment the start counter for the next iteration:

The whole flow will look like this:

If this helps & solve your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks