I am facing a performance issue in MS Flow that needs to track the 12-column dates with the logic of business days (ignoring weekends) on the SharePoint office site. We have a SharePoint list with 12 columns and we need to derive dates in no. of days given another list. This has been achieved using Do While Loop in the MS flow that is taking 2 minutes to execute this logic.
Is there a direct formula to calculate the logic of working days in MS flows? Or any other approach than the DO – WHILE loop in MS Flow?
The flow execution time is also not consistent.