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.72 / 5
Over 26910 Reviews
Good session. Keen to learn more as I already knew some stuff. -MS Teams Brisbane
Karin - MS Teams, .
Very informative Would be good to have a booklet to review what was learnt in the course Steven to follow up on Power BI booklet for Melina Berthaux -MS Teams Brisbane
Melina - MS Teams, .
Good course, the afternoon was more relevant for me. The morning was more of a referesher -MS Teams Brisbane
Colin - MS Teams, .
happy with outcome. -MS Teams Brisbane
Wayne - MS Teams, .
Course was presented at a good pace and kept us interested. Steven was a good trainer and kept the group included and ensured we all kept up. -MS Teams Brisbane
Tammy - MS Teams, .
Presenter was clear and concise and knowledgeable -MS Teams Brisbane
Kevin - MS Teams, .
Good training with a knowledgeable trainer. -MS Teams Brisbane
Emma - MS Teams, .
Another great session, thanks to Jason for taking us through more functions of Power BI. I feel much more equipped to use the program for my work now. -Power BI Intermediate Brisbane
Bek - Power BI Intermediate, .
Good refresher -Excel Intermediate Brisbane
Shani - Excel Intermediate, .
Great class - I picked up some really good tricks and methods. -Excel Intermediate Brisbane
Melinda - Excel Intermediate, .
learnt a lot from Stuart, looking forward to the advance course -Excel Intermediate Brisbane
Andrea - Excel Intermediate, .
Great course, learned heaps! Good pace. Easy to follow online. -Power BI Intermediate Brisbane
Ashleigh - Power BI Intermediate, .
Found that the Intermediate course was great as a refresher but I did learn some great tips. -Excel Intermediate Brisbane
Suzanne - Excel Intermediate, .
Great building on the beginner course and some amazing things possible. Jason as always is excellent!!! Friendly, responsive to questions. Good resources to link into as well. Thanks very much -Power BI Intermediate Brisbane
Clea - Power BI Intermediate, .
This course was very good for me I learned a lot in the class today -Excel Beginner Sydney
Debra - Excel Beginner, .
I really enjoyed learning from Michael and will definately use what I have been taught. An excellent and approachable way to learn Excel. Thank you! -Excel Beginner Sydney
Marcia - Excel Beginner, .
Michael was very attentive and helpful. He kept pace and time for the course but was always happy to assist anyone needing help. The course itself was a great refresher and I am looking forward to returning for an Intermediate Excel course to further my skills. -Excel Beginner Sydney
George - Excel Beginner, .
Michael was very helpful and made it fun. -Excel Beginner Sydney
Melissa - Excel Beginner, .
I found this course informative and easy to understand -Excel Intermediate Melbourne
James - Excel Intermediate, .
Great course, thanks -Excel Intermediate Melbourne
Jake - Excel Intermediate, .

Trusted by Business

Procured by Government

Awards and Accreditations

Nexacu offices Australia

Follow us