Finding Number Of Working Days Between Two Dates Using Power Automate Flow

Introduction

In this article I have explained how to find the number of working days between any two dates.

Steps to start the Flow

Step 1

Open flow.microsoft.com here

Step 2

Select +Create from the left panel.

Finding Number Of Working Days Between Two Dates Using Power Automate Flow

Step 3

Select on Automated cloud flow, you will get the window below

Step 4

Select When an item is created, then click on Create button below to create a flow.

By the above steps the flow will be created like below. I have here renamed the Flow as Finding the working days.

Flow to find the number of working days

Click on New Step,

Rename it to Start Date and select Project Start Date from the dynamic content list.

Similarly create or copy this one to My clip board and paste again and add a Data compose for Project End date.

Now choose an action Do Until

Select Add an Action inside the Do Until Action.

Now outside the Do until action add a new step and initialize variable add Apply to Each and add condition.

The output of Weekdays is the solution of finding the number of working days between the Dates.

Now we will see how to send an Email

As we have started the flow with When an item is created, now we will see how to create an item in the Share Point list which I have given as a reference.

In my last article “Project Management Application (Create Project) Using PowerApps And SharePoint Online” I have given an idea to save all the input from Power Apps to the Share Point List.

Now when we click on Create Project, a record will be created in the SharePoint List and an Email will be triggered. Below screenshot is for Reference.

Email Notification

*Limitation: The way of finding the days is limited up to 60 days. This process can be mostly used to find the shorter duration like Task days.

Conclusion

As there is no direct way to find the number of working days by using Power Automate, with this process I found a good way to meet my requirement. I hope you will enjoy working with this in your project requirement.