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