Unanswered

Export Outlook Calendar events and save them to an Excel sheet

(0) Share

Report

Posted on by Will_D

Hello, I did some searching and tried several proposed solutions for something like this in the forum but still cannot get the flow to work. I would like to have a flow that backs up my outlook calendar to an excel spreadsheet. It would do so on a regular integral like at the end of each day. Here is sample of flow I have tried.

I can see in the failed output message like this. It's like its trying to read my calendar and takes several minutes to run but its getting 404s. I have tried playing with the "skip count" and "top count" numbers.

I made the excel sheet ahead of time with this table and fields, figuring it would need the ID to tie things together.

Thanks for any help!

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Will_D

To add a row in excel sheet, pls use "Add a row into a table" action:

"Update a row" is basically used for updating the record already present in the excel sheet.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Will_D 34 on at

Like (0)

Report

The flow runs successfully now and it appears to be seeing all the calendar events and outputting them into the excel on the "add a row" task, however, my excel spreadsheet has no data when I check it. I see in OneDrive it is updating the "last modify date" on the spreadsheet too. So it's touching the sheet but no data. I will try re-building the flow. I don't see anything wrong now. Any ideas?

Was this reply helpful? Yes No
Will_D 34 on at

Like (0)

Report

Still no idea what is wrong, here is the full flow again.
And here is example of one of the many calendar events successful output.

Was this reply helpful? Yes No
Will_D 34 on at

Like (0)

Report

I tried completely rebuilding the flow from scratch and also tried having it go to a spreadsheet on a sharepoint as opposed to my one drive. The flow is successful, looks okay, but never writes anything into the spreadsheet. The spreadsheet looks like this.

Was this reply helpful? Yes No
Will_D 34 on at

Like (0)

Report

Just updating so this thread won't close. I have not been able to find a solution to automate this. For now I am manually exporting from Outlook and putting into an Excel.

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Will_D

If you are looking to add events from outlook to excel sheet, then you could use "Get calendar view of events" action. In that action, you could pass the start time as start of the day & end time as the start of next day. It will give you all the events which are schedule for current date in daily recurrence flow run. Those results you could save in the excel sheet. Here is an example:

After recurrence action, add "Get calendar view of events (V3)" action and set the expression in Start time & End time parameters. Both expressions need to be added in the expression box as highlighted below:

Expression used for Start time:

startOfDay(utcNow())

Expression used for End time:

startOfDay(addDays(utcNow(),1))

Next, add "Apply to each" action and pass value object dynamically from previous action. Inside it, add "Add rows in a table" action and set the parameters as shown below:

Flow Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Will_D 34 on at

Like (0)

Report

Hi, built a new flow exactly like you described. It fails. In past attempts I have had the flow work successfully but just not populate the excel at all.

{
  "status": 400,
  "message": "Invalid value 'startOfDay(utcNow())' for parameter 'Start Time'.\r\nclientRequestId: ce4121da-8dcb-4292-9487-67cb3975b334",
  "error": {
    "message": "Invalid value 'startOfDay(utcNow())' for parameter 'Start Time'."
  },
  "source": "office365-ncus.azconn-ncus-001.p.azurewebsites.net"
}

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Will_D

Could you please share the screenshot(s) of the entire flow in edit mode?

Thanks

Was this reply helpful? Yes No
Will_D 34 on at

Like (0)

Report

Sure, here you go.

Was this reply helpful? Yes No
Will_D 34 on at

Like (0)

Report

Trying again. That didn't paste in well.

Untitled.png

Was this reply helpful? Yes No