FLOW: Export appointments` data from Outlook to Excel table

[hjenei]

Hi,

I need to make monthly and YTD reports of my team`s activities which we all log in our Outlook calendars.

Is there a way to make FLOW add a row (with desired fields) to Excel wookrbook for every new appointment in Outlook?

Looking forward to your suggestions.

Many thanks and BR,

Hrvoje

[v-yamao-msft · Accepted solution]

Hi @hjenei ,

Do you want to get all the events from Outlook calendar within a specific time range then insert them into an Excel table?

Before starting the flow, please create an Excel table with the fields you want and upload it to a cloud storage account, I am using OneDrive for Business.

Start the flow with a Button trigger, which could be replaced with a Recurrence button for your scenario.

Then Get calendar view of events (V2), set the Start time and End time separately with the following function:

utcNow()

addDays(utcNow(),7)

Add the action add a row into a table, with dynamic content for corresponding fields.

Best regards,

Mabel