Building a Microsoft Flow that Populates Excel workbook with Email information

  1. Prepare an Excel workbook (save it in OneDrive or Teams or SharePoint) with the following fields listed as shown:

Fig 1. Create a Workbook in an online repository like SharePoint. Add your table

  • In Flow start creating a new Flow with the Event being “Receiving a Gmail” . Click on the Advanced Options. Enter the criteria you need, for example,   

Fig 2, Add an Event item at the beginning of your flow

  • Add an Excel step as shown below (“Add a row”). It will display the fields it finds in the table you specified. In my example I have a table with three columns : Email Received Date, Subject, Sender’s Name. You type the Dynamic Content item in that pop up box as per Fig 4., below. Click the Gmail item that appears. This will add itself to your “Add a row into a table” form, as per Fig 3. Repeat for other table fields.

Fig 3. Add a second step to your flow “Add a row into a table” form the Excel set

Fig 4. Type “Sender” into the Dynamic Content pop up. The Gmail item “Sender’s Name” appears

  • Click Save. See Fig 5.

Fig 5. After adding all your Flow elements (steps) click the Save button

  • In the top right hand corner of you screen click on “Flow checker” and then “Test”.

Fig 6. Click Flow checker and Test

  • The result of the flow looks like this in the Excel Workbook:

Fig 7. Excel is now populated with your Email information

Power Point Tip 1

When preparing a PowerPoint presentation, is it generally good advice to keep the number of slides small and the amount of text on each slide small?

As per the Quora question above I provided the following answer :

It depends largely on your audience and type of talk. But one thing I have noticed over the years is that not only from real world experience but from those who study such things, is that each slide should VISUALISE the point just made. That is, a single graphic presented just as you finish your point. Give your audience a chance to see and understand the graphic and then let them ask a question or two about that point and the graphic. Generally you don’t combine text with graphics. But if it is unavoidable be prepared that the audience can see the text. Also make ALL presentations as short as you can. If you can make your message in 1 minute do so!

Excel Tip 1

I get asked a lot about retrieving unsaved documents. I usually refer people to the Recent folder :

C:\Users\User\AppData\Roaming\Microsoft\Windows\Recent

but not all files are accessible from there. Especially partially corrupt ones. So I was pleased to notice the following tiny hidden button in the File –> Open pane :

Excel