Unanswered

Export Outlook Calendar events and save them to an Excel sheet

Like (0) Share

Report

Posted on 18 Dec 2023 17:03:14 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!

All responses (13)

Answers (0)

Will_D 34 on 02 Jan 2024 at 13:18:31

Like (0)

Report

Re: Export Outlook Calendar events and save them to an Excel sheet

Hi, its back to being successful on a run but still never puts anything into the excel sheet. It's okay, I'm good exporting this by hand since this just doesn't work. I have other flows that have no problem writing to an excel file so I don't understand why this one is not working. Thanks for trying to help!
ManishSolanki 15,085 Super User 2025 Season 1 on 28 Dec 2023 at 15:39:11

Like (0)

Report
Re: Export Outlook Calendar events and save them to an Excel sheet

Hi @Will_D

Expression should be added in the expression window, it should not be directly entered into the input parameter in "Get calendar view of events (V3)" action.

Now worries, now copy the below expressions & paste directly in the textbox:

Start time:

@{startOfDay(utcNow())}

End time:

@{startOfDay(addDays(utcNow(),1))}

The action should look like:

Pls retest the flow after modifying start & end time parameters.

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

Thanks
Will_D 34 on 28 Dec 2023 at 15:08:17

Like (0)

Report

Re: Export Outlook Calendar events and save them to an Excel sheet
Will_D 34 on 28 Dec 2023 at 15:07:05

Like (0)

Report

Re: Export Outlook Calendar events and save them to an Excel sheet

Trying again. That didn't paste in well.

Untitled.png
Will_D 34 on 28 Dec 2023 at 15:06:19

Like (0)

Report

Re: Export Outlook Calendar events and save them to an Excel sheet

Sure, here you go.
ManishSolanki 15,085 Super User 2025 Season 1 on 28 Dec 2023 at 14:54:52

Like (0)

Report

Re: Export Outlook Calendar events and save them to an Excel sheet

Hi @Will_D

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

Thanks
Will_D 34 on 28 Dec 2023 at 14:10:36

Like (0)

Report

Re: Export Outlook Calendar events and save them to an Excel sheet

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"
}
ManishSolanki 15,085 Super User 2025 Season 1 on 28 Dec 2023 at 05:11:21

Like (0)

Report
Re: Export Outlook Calendar events and save them to an Excel sheet

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
Will_D 34 on 27 Dec 2023 at 19:23:54

Like (0)

Report

Re: Export Outlook Calendar events and save them to an Excel sheet

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.
Will_D 34 on 20 Dec 2023 at 15:10:04

Like (0)

Report

Re: Export Outlook Calendar events and save them to an Excel sheet

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.