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

Microsoft Flow – Excel – Add a row into a table without failure

Flow Connectors One of the connectors in Microsoft flow is the Excel connector. Actually there are 3 connectors as I described in one of my past posts. I've seen many people complain that the connector doesn't work for them and the Excel file becomes unusable or it is locked resulting in the flow failing. I'm … Continue reading Microsoft Flow – Excel – Add a row into a table without failure