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.
- Create a SharePoint List, name it "Network Days"
- Create two SharePoint columns:
- Create calculated column, name it, "Alert Date"; add the calculation: =IF(WEEKDAY(Created)>3,Created+5,IF(WEEKDAY(Created)>1,Created+3,Created+4))
- Create person column, name it "Writer"; allow person only and make this field required.
- 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 accordingly.
- Create a new item and confirm date is 3 days plus the create date not including the weekend.
- Flow gets created and pauses until create date plus 3 working days.
- On Alert Date, you should receive the reminder email.
- Create a SharePoint List, name it "Network Days". You can do this by Adding an App and creating a custom list in a SharePoint Online team site.
2. Create two SharePoint columns:
- Create calculated column, name it, "Alert Date"; add the calculation: =IF(WEEKDAY(Created)>3,Created+5,IF(WEEKDAY(Created)>1,Created+3,Created+4))
- Create person column, name it "Writer"; allow person only and make this field required.
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/
*This post is locked for comments