When working with Excel in Microsoft Flow you will find that there are 3 connectors available.
- Excel Online (Business)
- Excel Online (OneDrive)
When you compare the 3 connectors you will quite quickly find out the differences.
What is the difference between these connectors?
Obviously the Excel Online (OneDrive) connector will give you access to Excel files stored in OneDrive.
The Excel Online (Business) is a bit less clear. This connector offers a similar set of actions that give you access to Excel files stored in SharePoint.
Then there is the last one left Excel.What is this about then? Apparently this is the old version of the Excel connector. When I tried it I couldn’t select the file name by clicking on the little folder icon.
Are there any triggers for Excel?
Yes there is a trigger but there is only one, but the weird thing is that when you search for excel and then click on a connector the trigger disappears. So it looks a bit like the trigger isn’t part of a connector. Which confirms my first screenshot in this post where the Excel connectors didn’t show any triggers.
And not until the tool tip appears is the trigger becoming a bit clearer.
So it is possible to specify a number of things here.
- SharePoint Site URL
- users/someone’s UPN
- groups/group Id
- sites/SharePoint Site URL: /teams/team name:” (the colon are required)
Aaaaahhhhh, which techie put this tool tip together. Do you understand this?
I really wish that my uservoice was implemented here. Of course the SharePoint URL option I can figure out. but “me”??? what does that mean?
Then now it’s time to look at the real stuff that you can do with Excel. For my examples I’m going to place my Excel file in SharePoint. then I”ll have a look at how to build a table in my excel file.
In most of the actions you will find a source (In my example this is a SharePoint site). Ok, I can still understand this.
But then the option Drive? Again what does this mean. Luckily Flow offers my suggestions and Drive is the document library.
Ok, The Excel connectors are still preview. So hopefully these issues will all improve soon.
After running the create table I got the following result in my spreadsheet
The second attempt ( after I emptied my spreadsheet) I had more luck.
Ok, this is great! With all the other option available like adding row, get a row I’ve got yet another option to store my data in. Personally I don’t like storing data in spreadsheet. My main reason for this is that people build up their spreadsheets manually and spreadsheets easily become unstructured. However, using the data table structure in Excel is a great way to store data from Flow or PowerApps.