Create Outlook calendar event from Excel

Like (0) Share

Report

Posted on 10 Apr 2023 15:46:06 by Mike44

266

I've created a very simple flow that allows me to create Outlook calendar events from a one row Excel table. The first few times I ran it, all went well. Now when I run it, it's creating events, but the dates and times are all wrong. When I check the output of the 'List rows present in table', the date and time is correct, but not correct in the 'create event (V4)'. Below is a screen shot of my flow and the outputs. I use a button in Excel to trigger the HTTP request.

All responses (3)

Answers (1)

v-peijunz-msft Microsoft Employee on 12 Apr 2023 at 05:36:02

Like (0)

Report

Re: Create Outlook calendar event from Excel

Hi @Mike44

Glad to see you solved the problem.
You could mark your answer/solution as a 'Solution' to allow more people with the same problem to solve their own problem as quickly as possible.
Thank you so much.

Best Regards,
Sylvia
Verified answer

Mike44 266 on 11 Apr 2023 at 12:02:36

Like (0)

Report

Re: Create Outlook calendar event from Excel

I appreciate the help, but I figured it out on my own. My problem was that I forgot that while recreating the table, I had changed my column names from the previous table. Stupid me.
Venoo 71 on 10 Apr 2023 at 17:54:15

Like (0)

Report

Re: Create Outlook calendar event from Excel

This looks a little bit odd. Seems not right.
Try pretending your date is on UTC, but use expression to convert time zone.

convertFromUtc(<enter your date block here>,700)

This formula will change the time to US/Canada Timezone -5
Time Zone IDs (Compact 2013) | Microsoft Learn
But this is how far my knowledge would go, as I never used create events in my projects so far.