Microsoft Flow Community Blog

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.

Flow - Calculate Date Diference

by Mdorrani on ‎07-12-2018 08:22 AM

Calculating the date difference in MS Flow using Flow expression method ticks()






Creating a List Reminder Flow

by ScottShearer on ‎07-10-2018 01:43 PM

How to create a Flow that sends email reminders based on data in a SharePoint list.


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.


Flow Approval Review Methods

by Super User ‎07-08-2018 08:25 PM - edited ‎07-09-2018 08:07 AM

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.