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 – 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

Microsoft Flow – Working with Excel, Excel and Excel

When working with Excel in Microsoft Flow you will find that there are 3 connectors available. Excel 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 … Continue reading Microsoft Flow – Working with Excel, Excel and Excel

Fix Corrupted Microsoft Office files

As recently mentioned in one of my blog articles. I found some interesting tools to fix various types of corrupted files. Today I'm going through the typical error that you might find. In this article I've created a an Access database but you could try the same with any of the following: Outlook .pst files Excel spreadsheets Word … Continue reading Fix Corrupted Microsoft Office files