Days Difference using PowerAutomate

(0) Share

Report

Posted on by MJS

Hi Team,

I would like to calculate elapsed days using PowerAutomate excluding weekends.

I have a column called SubmitDate in SharePoint. Elapsed Days should be Today - SubmitDate excluding weekends.

@ScottShearer

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-litu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @MJS,

You could following these steps to approach that:

1. Initialize several variables to store Today, submit day, and count days.

2. Create a Do until action to count days, if today does not equal to the weekend, add 1 day based on the count days variable, or do nothing. For each run, we should add 1 day to the Today variable.

dayOfWeek(variables('Today'))

PS: The default looping limits is 60, we could set it to 5000 to make it could count 5000 days difference.

I export the Flow and upload it, you could click the zip file under the post and import it into your Flows to test it.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DaysDifferenceusi...

Was this reply helpful? Yes No
MJS 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response. SubmitDate can not be greater than Today! Its a past date.

Thank you.

Was this reply helpful? Yes No
MJS 5 on at

Like (0)

Report
Copy link

Link copied!

Any help would be appreciated.

@ScottShearer

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MJS,

OK. I modified my Flow, set the summit day less than today, and logic has been modified.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DaysDifferenceusi...

Was this reply helpful? Yes No