Collecting emails and storing details in Excel using Microsoft Flow

Recently I was asked if it is possible to collect emails from a mailbox and store the email details in for example Excel using Microsoft Flow. Using Flow it is actually extremely easy to create an mail box as a way for people to update a data source. In my example here I will use … Continue reading Collecting emails and storing details in Excel using Microsoft Flow

Advertisements

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?

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