Configuring an action in Microsoft Flow using Excel Online Business in SharePoint or Microsoft Teams

Microsoft Flow can connect to an Excel spreadsheet stored in Microsoft Teams, SharePoint, or OneDrive for Business easily using the Excel Online (Business) connector.
When adding an action to your flow, search for “excel” and click on the connector titled Excel Online (Business)
   

This connector provides the following actions;
  • Excel Online (Business) - Add a key column to a table
  • Excel Online (Business) - Add a row into a table
  • Excel Online (Business) - Create table
  • Excel Online (Business) - Create worksheet
  • Excel Online (Business) - Delete a row
  • Excel Online (Business) - Get a row
  • Excel Online (Business) - Get tables
  • Excel Online (Business) - Get worksheets
  • Excel Online (Business) - List rows present in a table

Upon selecting the desired action the following parameters need to be specified;
Location – The source location of the Excel file, in the dropdown you can easily select OneDrive for Business, a Group (i.e. team), or a SharePoint site.
If the location you are looking for isn’t listed, you can also specify the location in the text box with the one of the following;
  • "me"
  • "SharePoint Site URL"
  • "users/someone's UPN"
  • "groups/group Id"
  • "sites/SharePoint Site URL:/teams/team name:" (the colons are required)

Document Library – The document library / directory to search in.
File – Which Excel file to access in the provided directory
Table – Which Table inside of your Excel spreadsheet to access
Microsoft Flow is a powerful tool and the ability to connect to Excel workbooks stored in various locations is extremely useful, if you create a Team in Microsoft Teams and add a shared Excel spreadsheet, you can link this into Flow to automate your processes will little effort.
If you have an Excel document stored in OneDrive for Business no problem, just select “OneDrive for Business”, or if your file is stored on a SharePoint site, just select your site from the dropdown box, easy!

How to add an Excel Online Business action

  1. In your Flow, click “Add an Action” or “Next Step”
  2. In the “Choose an Action” popup, type in Excel
  3. Click on “Excel Online (Business)”
  4. Select your desired action from the list
  5. Next you will be prompted for some information about your Excel document
  6. First select the location of your Excel Online Document, you can refer to the formats listed at the top of this article, or use the dropdown to specify a location on SharePoint, a group, or your OneDrive.
  7. Next, you’ll need to specify the document library, or directory your Excel file is stored in, you can pick from the drop down menu.
  8. Next you will need to specify the Excel File you want to use from the provided location and directory.
  9. Lastly, select the Table in your Excel file you’d like to use.
With your action added you can now combine Excel with other services to use your data as you need.

Was this helpful?

Yes No


Comments