Microsoft Flow – Custom Connectors – How to read an Excel file from SharePoint?

A while back I wrote a post about reading Excel files stored in SharePoint using Microsoft Graph. This has been a post that has been helpful to many people so why hasn't this been turned into a custom connector? Do you remember the reasons for a custom connector? Flow doesn't support something yet. Flow supports … Continue reading Microsoft Flow – Custom Connectors – How to read an Excel file from SharePoint?

Advertisements

Microsoft Flow – Read large Excel files within seconds without creating tables using Microsoft Graph

In Microsoft Flow it is possible to use the Excel connectors to read data form a spreadsheet. there are however a few major issues with doing this:  You data needs to exist within Excel Tables. Large tables take long to load. (4000 rows takes about 2 minutes) The Excel connector likes hard coded names for … Continue reading Microsoft Flow – Read large Excel files within seconds without creating tables using Microsoft Graph