Hello folks,
As there are not any OOB endpoint for getting working days of a month or date range. I have created this flow to get working days i.e. excluding Saturday and Sunday of Month. You can customize according to you needs.
Follow below steps :
1) Compose action to set start date of month
2) create compose action again to set end date of month using following expression :
3) Initialize variable to set Start_Date as string and value of output #1 compose
4) Initialize an array - as array output of #1 compose . This is going to be used to loop through between date rang
5) Initialize weekend incremental counter variable
6) Create Do Until loop - set 'Start_Date' and compare output value with 'Compose_3' i.e. #2 step
- Create compose action again to add 1 day into start date with expression as follows : addDays(variables('Start_Date'),1)
- Now add action to set variable value of 'Start_Date' from previous compose output
- Add append to array variable - Select 'Date_Array' with value of 'Start_Date' - This is going to append array variable
7) Now after Do until, create action to compose array output for 'Date_Array'
Add apply to each loop - This is going to iterate through each dates we added in 'DateArray'
- Add conditions in each loop to check day is weekend or not using following condition : (Use OR)dayOfWeek(items('Apply_to_each')) is equal to 6dayOfWeek(items('Apply_to_each')) is equal to 0
- In Yes action , Increment Weekend variable to 1
9) Now After apply to each , create a new compose action with input of 'Weekend'. This is going to show you number of weekends of month.
10) Check using flow checker & Test.
If you have any questions or concerns , please feel free to reach out to me.
