Do you like the Network Days function in Excel? And do you need to create reminders to do a task but do not want to include weekend days - here is a trick to exclude them. You can re-create it with SharePoint Online and Flow in 6 simple steps.
2. Create two SharePoint columns:
3. Create a Flow from blank and name it "When an item is created - send an alert 3 days after create date". Select Trigger "SharePoint - When an item is created": Choose Site and List "Network Days"; Select "Add an Action" and type "Schedule - Delay Until": Add dynamic content "Alert Date" in Timestamp field; Select "Add an Action" and type "Office 365 Outlook - Send an Email": Add dynamic content "Writer Email" in the "To" field and format the Subject and Body accordingl
4. Create a new item and confirm date is 3 days plus the create date not including the weekend.
5. Flow gets created and pauses until create date plus 3 working days.
6. On Alert Date, you should receive the reminder email.
Resource:
Flow Action - Delay until: http://www.rjesh.com/2017/03/microsoft-flow-pause-till-date.html
SharePoint Weekday function: http://blog.pentalogic.net/2008/11/working-days-weekdays-holidays-sharepoint-calculated-columns/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.