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