Get the first working day of the month

[ZLucid]

Hi, all! 

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! 

[Pieter_Veenstra]

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.

[DLGross]

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

[v-xida-msft]

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:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

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,

Kris

[ZLucid]

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? 

Regards,

[Pieter_Veenstra]

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

https://veenstra.me.uk/2018/05/08/office-365-microsoft-flow-get-the-first-working-day-of-the-month/

[rupach]

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

Thanks

RupaCh 

[DLGross]

RupaCh, his link still works for me.

[rupach]

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...