24 Days of PowerPlatform – Day 14 – Excel (Online) and Flow

24dopp_day14

Excel Online and Microsoft Flow

In today’s post I would like to show you the teamwork between Excel and Microsoft Flow.

Excel, as one of the most used data collection, preparation and presentation tool – is a perfect starting point for “doing more with the data (in your spreadsheet)”.  In Summer 2018, the Microsoft Flow and Excel product groups announced the availability of the Flow integration for Excel Online tables. Using that functionality, you can directly start a Microsoft Flow out of your Excel table working with data contained in that file.

Flow functionality is not available out of the box in Excel Online – you need to activate the corresponding add-in first.

24dopp_day14_excelFlow_01

Search for the Flow add-in in the Office Store and add it.

24dopp_day14_excelFlow_02

If everything works fine, the Add-in is available in the “Data” ribbon afterwards

24dopp_day14_excelFlow_03

For todays example I add a simple table into the spreadsheet. Requests can be added to that list and the planned Flow will be an approval workflow to ask for approval.

HINT: you need a table within your spreadsheet to work with Flow integration

24dopp_day14_excelFlow_04

Start the Flow creation with the “Flow” action in the menu.

24dopp_day14_excelFlow_05

I think I’ve already mentioned it sometimes (or even more often) in my PowerPlatform series – use templates as starting points! 😊 Because, there is a template that should do the things planned (request approval).

24dopp_day14_excelFlow_06

Like any other Flow, the required connections are displayed, and you can change them if you want to use another user for example.

24dopp_day14_excelFlow_07

Let’s continue and a Flow development pane is opened. The generated Flow already contains two elements – the Excel trigger (for a selected row) plus the Approval start action.

24dopp_day14_excelFlow_08

The Excel trigger is pre-filled with the connection to the Excel file PLUS additional information that is needed for the following step – an approver email plus a message that can be entered by the requester.

24dopp_day14_excelFlow_09

The Approval action needs some more configuration settings – like the requester and approver information and details about the message the requester entered during the approval request.

The approval action generates an email that is sent to the approver. The request can then be approved or rejected.

24dopp_day14_excelFlow_10

 

What is missing in the generated Flow is the ability to return the approval result back to the user. As the Excel-integrated Flow development pane is not the biggest and brightest one I first save the Flow and then return to the list of flows to open the Flow in the Flow-Web editor.

24dopp_day14_excelFlow_11

In the Flow Editor, I added a new Action – a “condition” action that allows me to split the Flow into two separated branches: one for approval, one for rejection. Within those branches I added an email notification action to inform the requester about the result. The resulting Flow looks like:

24dopp_day14_excelFlow_12

And now – let’s see it in action:

  • Back to the file in Excel Online
  • Select one row in the table

24dopp_day14_excelFlow_13

In the dialog, start the new Flow. The approver email and the message from the requester is needed.

 

 

That’s it for the moment on the requester side. Let’s check emails at the approver inbox.

24dopp_day14_excelFlow_17

The approver can approve or reject the request. In my example – rejection!

24dopp_day14_excelFlow_18

The information email for the requester looks like this:

24dopp_day14_excelFlow_19

 

And with that – another example of the PowerPlatform in action comes to an end! I hope you liked the example.

Happy Flow-ing,

Wolfgang

Advertisements

About wolfgang

Data Platform enthusiast
This entry was posted in 24 Days Of PowerPlatform, Power Platform. Bookmark the permalink.

2 Responses to 24 Days of PowerPlatform – Day 14 – Excel (Online) and Flow

  1. Pingback: 24 Days of PowerPlatform – Day 23 – Flow and Cognitive Services | workingondata

  2. Pingback: 24 Days of PowerPlatform – Day 24 – Wrap Up | workingondata

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s