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.

 

What is Remote Training?

Valued by Individuals

4.8/5
Over 22036 Reviews
It has been a great experience. The reliance of subjects was related to my requirements. There was a great opportunity provided tailor an example to finish the course. -Excel Macros/VBA 2 Day Brisbane
Nicholas - Excel Macros/VBA 2 Day, .
Great Course, learnt alot and was easy to follow -Analysis & Dashboards Melbourne
Julia - Analysis & Dashboards, .
Excellent Training session -Analysis & Dashboards Melbourne
Rashmikant - Analysis & Dashboards, .
This course enhanced my knowledge in Excel -Excel Advanced Parramatta
Maria - Excel Advanced, .
Good Course -Excel Advanced Parramatta
Baminahannadige - Excel Advanced, .
Michael is a very good teacher, he is very thorough with his explanations. Knows how to deliver the message across very well, is clearly very experienced with Microsoft. I would definitely recommend him and would enrol for another one of his classes if need be. -Excel Advanced Parramatta
Estephanos - Excel Advanced, .
Course was quite good, I picked up quite a few things but as there is so much to cover some things were skipped through quite quickly. Jag was very good at making sure everyone understood. -Excel Intermediate Adelaide
Bev - Excel Intermediate, .
It was a great day - learnt a lot of new things :) -Excel Intermediate Adelaide
Deborah - Excel Intermediate, .
very well explained, easy to understand -Excel Intermediate Adelaide
Borbasi - Excel Intermediate, .
Very well Done -Excel Intermediate Adelaide
Vladimir - Excel Intermediate, .
Excellent. Good pace and learnt lots -Excel Intermediate Adelaide
Debra - Excel Intermediate, .
Jason covered the content well and was great at explained everything -Excel Intermediate Canberra
Lisa - Excel Intermediate, .
Great course & Jason was a great facilitator. Challenging working remotely on a laptop. I personally didn't have two screens available & I think that would make it a lot easier to navigate but that aside, the pace of the course allowed for minimal inconvenience. -Excel Intermediate Canberra
Kyle - Excel Intermediate, .
Very informative. Thank you for a great lesson -Excel Intermediate Canberra
Peter - Excel Intermediate, .
Great Course! Very informing and helpful! Great teacher who encouraged questions and answered them thoroughly; thank you! -Excel Intermediate Parramatta
Charbel - Excel Intermediate, .
good and prompt view of using excel -Excel Intermediate Parramatta
Vincent - Excel Intermediate, .
Very good and fast paced course with very key concepts covered. -Excel Intermediate Parramatta
Vladimir - Excel Intermediate, .
A great course to understand some extra perks on Excel Michael was very helpful and engaging! Would recommend this course -Excel Intermediate Parramatta
Joseph - Excel Intermediate, .
Good crash course and very helpful -Excel Intermediate Parramatta
Mohan - Excel Intermediate, .
Ken was really great, very passionate about experienced presenter. Really enjoyed the intermediate session. Got a lot of useful tips on how to work more efficiently in MS Project Professional. Thanks Ken -Project Beginner - Project Intermediate Remote Online
Therese - Project Beginner - Project Intermediate, .

Trusted by Business

Procured by Government

Map of Australia