All courses REMOTE until June 30 | Limited in-class sessions in June - Call Us | From July 1 all courses available in-class and remotely

Create a flow from Excel

Microsoft Flow August Update

August 22, 2018

How to Build and Run Flows in Excel

With the new August updates in Flow you can now create Flows directly from Excel. This is done with the new Flow button where you can create and trigger automations from Flow. You can create and run-on demand flows. For selected rows in any Excel table on spreadsheets hosted in SharePoint or OneDrive for Business. This addition, works similarly to Excel Macros. But the benefit is that it's easier to share your flows and connect it to external data sources and third parties.

To start using Microsoft Flow in Excel. Start by going to the Insert tab in Excel located in the ribbon and select Store. After that, in the dialog box, search for “Flow”. Find Microsoft Flow in the drop down and then add the add-in.



Once the Flow add in has been installed (may take a few moments) select the Flow button on the Data tab. From the Flow launch panel, build your flow by using the For a selected row trigger, or start from one of the templates:



 

After the flow is created, select a row, and then select the Play button to see your flow in action.

Create a flow for a Microsoft To-Do in Outlook Web App

One very useful feature Microsoft has recently launched in Outlook is the ability for a sender to explicitly call out a person on the recipient list to draw his or her attention to the email. This is done by including the at sign (@) before the name of the person, which causes the name of the recipient to be highlighted in the email and the recipient’s email to be automatically included in the To line.

By @mentioning someone in an email, you can call the recipients attention to an action item assigned to them.

The task contains the context from the email for reference, such as the send and the body of the email. The recipient can add additional context, such as the due date and categorization, from within the To-Do app. At this time, this functionality is only for Outlook Webb App.

To learn more about Microsoft Flow check out our course. Additionally check out our Flow archives to learn how to design more of your own flows.

 

What is Remote Training?

Valued by Individuals

 

4.8/5
Over 20822 Reviews
Great Explanations, Very Helpful, Highly recommend. -Excel Intermediate Perth
Luke - Excel Intermediate, .
Jagg was really great, good amount of detail and a good pace, made it easy to keep up and really learn everything. Thank you -Excel Intermediate Sydney
Madelene - Excel Intermediate, .
Great communication skills -Excel Intermediate Perth
Anthony - Excel Intermediate, .
. -Office365 Intermediate Sydney
James - Office365 Intermediate, .
Helpful and well explained -Office365 Intermediate Sydney
Monika - Office365 Intermediate, .
John was really good at power BI and some of the concepts were great. I will keep all these details close by and even reach out to John if I have further questions. Thanks for the day! -Power BI Advanced Canberra
Matthew - Power BI Advanced, .
Thanks -Power BI Advanced Canberra
Gabriela - Power BI Advanced, .
The training was really great. Jag kept us engaged for the whole day which is great. I learnt a lot and can't wait o put the tips and tricks in action. Thanks -Excel Intermediate Sydney
Rosalind - Excel Intermediate, .
Jag is so very good! Was very engaging and actually very fun! -Excel Intermediate Sydney
Michelle - Excel Intermediate, .
Good overall -Power BI Advanced Canberra
YuinAi - Power BI Advanced, .
Michael was great - he had a good pace and checked in with us to see if we had any questions. He is clearly very passionate about Power BI which enhanced the whole experience -Power BI Beginner Sydney
Ally - Power BI Beginner, .
It was very informative and Michael was very helpful and detailed. -Power BI Beginner Sydney
Alan - Power BI Beginner, .
Very good introduction to PowerBI. Concepts very well explained. -Power BI Beginner Sydney
Eric - Power BI Beginner, .
Thanks Ken, very informative. -PowerPoint Level 2 Sydney
David - PowerPoint Level 2, .
Thank you was a great session. -PowerPoint Level 2 Sydney
Nikita - PowerPoint Level 2, .
Really useful tips and shortcuts -PowerPoint Level 2 Sydney
Devlin - PowerPoint Level 2, .
Thanks- great course! -PowerPoint Level 2 Sydney
Gabrielle - PowerPoint Level 2, .
Helpful. Thank you very much. -PowerPoint Level 2 Sydney
Guida - PowerPoint Level 2, .
Wonderful course. Enjoyed it very much and learnt many new features -Power BI Beginner Sydney
Victor - Power BI Beginner, .
. -Power BI Beginner Sydney
Steve - Power BI Beginner, .

Trusted by Business

Procured by Government

Map of Australia