Power Platform Community Forum Thread Details

Hello,

I am trying to create a flow that will cycle thought my SharePoint list and find the number of business days between two give date fields "Date received" and "Date complete" for each entry. I then want to insert that number into field "Days Needed" for each item.

I don't need holidays taken out.

Example:

"Date received" 1/1/2024 "Date complete" 1/12/2024 Equals 10 Business days. Update "Days Needed" field with "10" move to next line repeat flow.

Any help would be appreciated

Categories:

Building flows

hi @JasonM2457

First hit, of many after typing what you want.. its all over. It would be good to search for them and try them and share what you tried, as we don't like having to write everyones stuff for them.

My query on Bing - find number of business days between dates in power automate

How to count business days between two dates in Power Automate – Digital Mill

As for the other, please write some of the flow and come back if you are lost.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey