All courses available in-class or via remote login

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.

 

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 23724 Reviews
Very detailed and has given me a good start with Power BI. -Power BI Beginner Brisbane
Jessica - Power BI Beginner, .
Terrific course. Well explained. Thoroughly enjoyed -Power BI Beginner Brisbane
Keirin - Power BI Beginner, .
Excellent course, well run and good topic coverage. Looking forward to the intermediate course. -Power BI Beginner Brisbane
Allister - Power BI Beginner, .
Steven is always a great trainer, a lot of content I can use at work. -Power BI Beginner Brisbane
Tys - Power BI Beginner, .
Very good advanced information. -Power BI Intermediate Adelaide
Rhett - Power BI Intermediate, .
Great session. Jagg is brilliant in the way he is able to present in an online forum. -Power BI Intermediate Remote Online
Brett - Power BI Intermediate, .
Great session -Power BI Intermediate Adelaide
Emily - Power BI Intermediate, .
Excellent -Power BI Intermediate Adelaide
Hikkaduwa - Power BI Intermediate, .
Good beginner's introduction to Office 365. Thank you John! I would like a certificate of completion please. -Office365 Beginner Remote Online
Yieng - Office365 Beginner, .
I learned a few new things which was great -Office365 Beginner Remote Online
Jacqui - Office365 Beginner, .
thank you -Office365 Beginner Remote Online
Cindy - Office365 Beginner, .
John provided very good training and it will really helpful to myself and our organization. We have learn a lot new things. really useful -Office365 Beginner Remote Online
Chetankumar - Office365 Beginner, .
good overview of Office 365. Good use of MS Teams to deliver training. -Office365 Beginner Remote Online
Nathaniel - Office365 Beginner, .
Great session that was easy to understand - thank you -Office365 Beginner Remote Online
Aaron - Office365 Beginner, .
thanks John he was really engaging and clear on how we can use Office 365 -Office365 Beginner Remote Online
Marc - Office365 Beginner, .
Great training. John was very engaging and covered a lot of content. Customised to our needs and where we are up to in our O365 journey. Thank you! -Office365 Beginner Remote Online
Emily - Office365 Beginner, .
loved it, very clearly explained good interaction and very helpful -Office365 Beginner Remote Online
amy - Office365 Beginner, .
Well rehearsed. Very informative. Very knowledgeable. -Power BI DAX Brisbane
Julian - Power BI DAX, .
Great presenter, willingness to answer questions (even when off topic) was appreciated. -Power BI DAX Brisbane
Bill - Power BI DAX, .
Enjoyed the course, plenty of content to digest. -Power BI DAX Brisbane
Tim - Power BI DAX, .

Trusted by Business

Procured by Government

Map of Australia

Follow us