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
Fig 7. Excel is now populated with your Email information
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