Showing results for 
Search instead for 
Did you mean: 
New Member

Get the first working day of the month

Hi, all! Cat Happy


I have a requierement in which my flow should be trigger every first (third and fifth) working day of the current month.


For example, in May the flow should run on the 2nd of May, since the 1st is a holiday. Please note that this has to be in accordance with the regional holidays. 


Is this functionality available in Flow?, if not, is there a workaround? Or is it just completely impossible to achieve so far in Flow? 


Thank you! Cat Very Happy






There isn't an easy way to get this done at the moment. Without any coding you could potentially make use of webservices out there that give you the next working day and use a HTTP action to connect into those services.

Kudo Kingpin
Kudo Kingpin

A possible workaround would be to create a Calendar in Sharepoint, enter the holidays and other days that you need to keep track of, then in the Flow use the DateUTC function and compare it to the reference calendar to see if it contains an event. I haven't tried this in flow, but this approach is commonly done in database reporting

Dean Gross

Office 365- MSCA
SharePoint - MCSE
Microsoft 365 Enterprise Administrator Expert
Community Support
Community Support

Hi @ZLucid,


Do you want your flow to be fired every first (third and fifth) working day of the currently?


There is no way to check if the current day is a holiday in Microsoft Flow, I afraid that there is no way to achieve your needs in Microsoft Flow currently.


If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:


In addition, I agree with @DLGross's thought almost, you could consider take a try to create a Calendar event list in your SharePoint and enter these holidays and weekends into it. Then compare current day with the Start date of these holidays and weekends within the SharePoint calendar event, check if current day is included in the SharePoint calendar event list. You should use the "Recurrence" trigger as the trigger of your flow.


Best regards,


Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-xida-msft


Let me check if I understand correctly, in order to get the first working day of a month (or third or fifth), i should add them first to a list and (recurrently) compare the current day with the elements on the list, right? I understand how the Calendar will help me to get the holidays and weekends out, but i dont really understant how can that help me to get the first working day of a month. 😞 


And currently there is no "out-of-the-box" solution for it in Flow, right? 




Please have a look at my latest blog post about getting the first working day.

Hi Pieter,


Could you please help me with the webservice which gives first working day in a current month .?

The link you have provided in the solution was no longer available






RupaCh, his link still works for me.

Dean Gross

Office 365- MSCA
SharePoint - MCSE
Microsoft 365 Enterprise Administrator Expert

I am not able to :(..


I am seeing below message...


Could you please help me to find an solution  " Getting the First working day of the month " in microsoft work flows...


URL-Not Found.PNG

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,979)