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

[ilijacrnobrnja]

I followed all the steps and the test flow ran successfully. However, the event information is not coming to the spreadsheet. Please help. Thank you.

[heval]

Also followed those steps, nothing happens in excel while test on flow is succeed.

[TheStig]

I did the same and followed all the steps as well and got Errors 

Invalid Value (UtcNow)..i cant seem to attach the screen print ..any help would be great to export my list of Calendar events to an Excel File !