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.

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

 

Capture.PNG

 

Capture.PNG

Read more...

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

Read more...

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.

Read more...

Flow Approval Review Methods

by Super User a week ago - last edited Monday

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...

This week will give you a sneak peek at the Microsoft Flow template that will be soon featured on the Microsoft Flow Twitter account for #TemplateTuesday! Also I have some exciting news about myself and the Microsoft Inspire Conference in Las Vegas, June 16-19! Community Threads are under the Spotlight this week. I'll go over some awesome threads and ideas that I think should be spread for more users to see and contribute on. And I will also go over some key values and goals that we need to have as the great Microsoft Flow Community. Enjoy!!

Read more...

In this article I'll round up some great news and updates about the MBAS and give you the links to check out how you could benefit from attending this awesome first time event! 

Read more...

Microsoft Flow is not only practical for use in streamlining business processes, it can also be used to help make remembering the things in our every day lives a bit easier! Have you ever created a Flow that will somehow help you out with something that you deal with your tasks or duties on a regular basis? Have you ever wanted to do so, but you've just never taken the time to stop and create it?

Read more...

MBAS_General Banner Ad_728x90.png

Time is running out! Join our community, partners, and experts at Microsoft Business Applications Summit.

Read more...

This week in Community Corner I am going to first show you a few of our newer Flow Templates that I think many Flow users would be able to utilize for their business processes. Then I will tell you about some of my favorite Flow content creators and what they've been up to lately, and i'll link you to all of their content and webpages. Lastly I am going to highlight an outstanding Flow community member and some of the awesome work that they have contributed recently! Hope you enjoy!

Read more...

Flow Community Blog Author Request

by Community Manager 2 weeks ago - last edited 2 weeks ago

Do you have a Flow building experience that you would like to share with the entire Flow Community? Could you sum it up in a blog article with screenshots and simple directions? Would you like to write that article here, on the Microsoft Flow Community Blog Page?!?

Read more...

Syncing Storage Areas in Teams Tabs with Flow

by themsenduser 3 weeks ago - last edited 3 weeks ago

It is possible to add a document library as a tab in Teams channels, and this post is going to show how you can sync (creation and deletion) such a document library with an external storage source (this use case is for DropBox) via Flow.

Read more...

Do you ever just want a quick and efficient way to create a request workflow? There are several ways to create a request approval process with Flow and I am going to show you one of the ways that has worked for me.  This request process is specific for a vacation request approval flow but can easily be used for any type of request.  I will provide you with 5 easy steps for you to successfully create the approval process using a modern SharePoint Online List.  This Flow is highly extensible and can even include multi-step approval processes.  For more information about multi-step approval check out Jon Levesque’s video: https://www.youtube.com/watch?v=f6ysuQUZ2wQ

Read more...

In this week's edition of Community Corner, I will go in depth about the different guest speakers and all of the different sessions that you'll have the opportunity to experience July22-24 at the 2018 Microsoft Business Applications Summit in Seattle, WA! Also in this article, you will learn about a hot new template release for Microsoft Flow along with a couple of new connectors! And finally for Community Spotlight this week I am going to explain some of the ways that the success and dexterity of our community can be maintained and even improved! Come see what peaks your interest in this week's Community Corner!

Read more...

Its 2018 and I am tired of carrying business cards. With Microsoft Flow I am able to solve that issue once and for all! Check out how I build a Flow that goes far beyond what any business card is capable of!

Read more...

Though you can externally share sites and documents in Office 365, sometimes, users need to send out documents to many external contacts, and would like an easier way to do this without having external users create a Microsoft account, without having to attach said document to an email.

Read more...

Do you have legal, vendor, procurement or other team that deals with contracts all day long and needs to improve the approval process?  And would these teams like to have one central storage location to manage, edit, approve and track the contracts?  Oh and review and edit them on any device at any time?  You can do all of this in a SharePoint Online modern document library with Microsoft Flow.  I will provide you with 5 easy steps for you to successfully create this process and be on your journey towards an efficient way to collaborate and mange your contracts.

Read more...

In this weeks Community Corner, you will read about many the wonderful Microsoft Conferences, Conventions, Workshops, Summits, & SharePoint Saturdays that are scheduled for the second half of the year that lies just ahead! You'll also get your regular update on the recently released Flow Connectors and what to expect from them! And last but not least, there's a Q&A appearance from a special guest to kick off a new segment that will close out every future Community Corner blog article!

Read more...

MBAS_General Banner Ad_728x90.png

Get ready to connect, collaborate and pack in as much learning as possible at Microsoft Business Applications Summit, the event for Dynamics 365, Power BI, Excel, PowerApps and Flow users, July 22-24 in Seattle. We’ve just announced our featured speaker lineup – you won’t want to miss these experts, plus three amazing keynotes. Check it out!

Read more...

Using Flow To Batch Schedule Tweets

by Community Manager on ‎06-14-2018 10:02 AM - last edited 4 weeks ago

In this article I will show you how to easily batch schedule Tweets FOR FREE using Microsoft Flow, Google Sheets, and AtBot. This is a somewhat simplified version of the Flow How-To created by @thatmattwade which offers a bit more than just scheduling batches of generalized tweets. I reccomend giving this article a read and then heading over to Matt Wade's Article to really see where this idea is coming from!

Read more...

With Flow, using metadata values to trigger actions is a relatively simple process that takes only a few minutes to set up! For any given list or library in Office 365 you can customize actions that your end users can eaily enable for their business processes by simply choosing a meatada value attached to a file that will trigger the process against the same file- and don't forget you can copy and re-use your Office 365 Flows to apply to multiple locations!

Read more...

Use Flow to Moderate SharePoint Image or Picture libraries

by Super User ‎06-10-2018 06:30 PM - edited ‎06-10-2018 06:37 PM

The potential of SharePoint is abundant and now with Flow you can do even more. However, with more power comes more responsibility and this is where Cognitive Service's can help. In this blog we'll see how the Computer Vision and Content Moderator connectors can help monitor the images that are uploaded to SharePoint libraries buy tagging them and also identifying those that are either racy or adult.

Read more...

Attachment
Attachment
Attachment

Flow Community Corner 03: Connectors/MBAS/Customer Stories

by Community Manager ‎06-08-2018 10:05 AM - edited ‎06-12-2018 12:00 PM

In this week's Community Corner you will have a chance to read up on the new and upcoming Microsoft Business Applications Summit! You'll get some details about the newest Flow connectors that were recently made available, and learn about a way that you or someone you know could tell a story that reflects how you've integrated Microsoft Flow into your business practices!

Read more...

Perform Flow actions further than 30 days from now

by Super User ‎06-06-2018 07:54 PM - edited ‎06-07-2018 07:15 AM

Currently, a Flow can only run for 30 days. But what if you need to perform actions beyond that timeframe? Not an uncommon scenario. Here's one way to do it, using a value in a SharePoint list, a recurrence trigger, and a delay.

Read more...

Flow for SharePoint Designer Workflow Developers

by ScottShearer ‎06-03-2018 06:19 AM - edited ‎06-05-2018 09:17 AM

Flow is the future of automation in SharePoint.  Now is the time to begin making the transition from Designer workflows to Flow.  In this article, you'll learn how Flow compares to Designer workflows and how to get started with Flow.

Read more...

Flow Community Corner 02: Connectors/Authors/News

by Community Manager ‎06-01-2018 10:03 AM - edited ‎06-05-2018 09:22 AM

In this week's Community Corner, you'll find exclusive updates, details, and interesting information about Microsoft Flow and the people who use it! Come take a look and see if you find interest in something new from this week!

Read more...

How To Send an Outlook Email for Each Microsoft Forms Survey Response

by Community Manager ‎05-31-2018 10:47 AM - edited ‎05-31-2018 10:51 AM

There is a template for Sending an Outlook Email for Each Microsoft Forms Survey Response that does not run properly due to the Forms Connector update. We recently came upon this discovery so now I will show you how to create the Flow from scratch to avoid having to use the broken template!

 

 

Read more...

If you have a customer with legacy reporting/BI/Visualization tools which sends out emailers with PDF attachments containing business sensitive information and which need to be protected, you can use Microsoft flow along with Sharepoint online and IRM to achieve it without doing a single change at the reporting layer. 
Read more...

Hey Everyone!

 

     Welcome to the first Microsoft Flow Community Corner Blog! I am Gabriel, the newest Community Manager! I am so excited to be a new member of this excellent online community and I am very proud to announce that you can expect an awesome info-packed Community Corner Blog post just like this one, every Friday, from yours truly! In the new Community Corner Blog, you can expect to see anything from updates on newly released Microsoft Flow Connectors to product check-ins with the Flow Product Team, to break-downs of how this great Community Works!

Read more...

In this article, I will describe how to extract values from email messages and store them somewhere with the help of Microsoft Flow or Azure Logic Apps. I will use Regular Expression Match action from our Plumsail Documents.

 

Let’s suppose you are getting a new email after someone made a purchase and you need to extract information from this email and create a new item in your orders SharePoint list.

Read more...

This blog focuses on how using Flow you can automate the process of monitoring incoming emails and create tasks in existing Plans in Planner. The Flow is smart enough to focuses on new emails only and ignore replies.

Read more...