Welcome to the Microsoft Flow Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.
Displaying articles for: 07-08-2018 - 07-14-2018
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.
Flow Connectors: SharePoint, O365 Outlook
What is the Network Days function?
The NETWORKDAYS function is a built-in function in Excel that is categorized as a Date/Time Function to not include weekends when calculating 2 given dates.
Use Case: When a SharePoint item gets created, I needed to add 3 days from the create date not including the weekends and email a reminder. The person field can be any type like assigned to, but in this case it is a writer that has to take action by the 3rd day after an item is added. This type of reminder system and exclusion of network days can work in many scenarios and here is one of them that worked for me.
When a Microsoft Flow Approval request is received by a user, there are a few convenient ways that it can be reviewed and either approved or rejected. The approval will be available in the Flow approval center and the mobile app. An approval email is also sent to the user's email address. No matter which method the user uses to approve or reject the approval, the outcome will be saved in the approval center history.Read more...