Microsoft Flow

Microsoft Flow is an online workflow service that automates events (known as workflows) across the most common apps and services. For example, you can create a flow that adds a lead to Microsoft Dynamics 365 and a record in MailChimp whenever someone with more than 100 followers tweets about your company.

When you sign up, you can connect to more than 220 services, and can manage data either in the cloud or in on-premises sources like SharePoint and Microsoft SQL Server. The list of applications you can use with Microsoft Flow grows constantly.

What can you do with Microsoft Flow?

You can use Microsoft Flow to automate workflows between your favorite applications and services, sync files, get notifications, collect data, and much more.

For example, you can automate these tasks:

  • Instantly respond to high-priority notifications or emails.
  • Capture, track, and follow up with new sales leads.
  • Copy all email attachments to your OneDrive for Business account.
  • Collect data about your business, and share that information with your team.
  • Automate approval workflows.
  • A common use of Microsoft Flow is to receive notifications.
  • For example, you can instantly receive an email or a push notification on your phone whenever a sales lead is added to Dynamics 365 or Salesforce.

    You can monitor what people are saying about your business by creating a flow that runs whenever someone sends a tweet with a certain hashtag. The flow can add details about each tweet to a Facebook post, a SQL Server database, a SharePoint list, or even a Microsoft Excel file that's hosted on OneDrive for Business-whichever service works for you.

    You can create actions to connect the data you collect to Microsoft Power BI, spot trends in that data, and ask questions about it.

    Things such as notifications, data collection, execution of stored procedures from apps, Twitter posts and Active Directory functions can be accomplished without writing code.There are dozens of pre-built templates to choose from that make adding Flows to your Power App solutions a breeze. Again, if you have Office 365 then you have Microsoft Flow.

    Building a time tracking flow

    1. Save the file (Save as) with the name Timesheet.xlsx.
    2. Let’s create the Track Time flow: go to and if requested, sign-in
    3. Go to My flows - Create from blank:
    4. Note: This trigger will start the flow by pressing a button. The button can also be visible in the flow mobile app, including in the home screen of a smartphone. If needed, a form can show up when the user pushes the button. But in any case, some default information like the current user coordinates and current time are captured automatically by flow when the button is pressed.
    5. Add the Excel Online (Business) Connector and select the associated action Excel Online (Business) Add a row into a table action. To do so, add a Location, Document Library, File and Table based upon the location of your spreadsheet in OneDrive for BusinessWhat we want to achieve is adding the current user address location and time stamp into the spreadsheet. Doing this will create a connection with the current user account.
    6. Once your table is launched you will see additional fields appear (column names) then fill in the action properties with DYNAMIC CONTENT (select them with the dropdown) with the following values: