Answered

Create SharePoint Calendar Event

(0) Share

Report

Posted on by djfg

I posted about this a few weeks ago but didn't get a response so trying again after tinkering with it on my own. I have a form that I am using in which employees set a date range (select two dates using date picker). My Flow then sends the item for approval, and if approved will send a confirmation email and add a row to an Excel table. I also want it to add an event to a Sharepoint Calendar. The problem I am running into, is once it hits SharePoint, instead of being entered as it is supposed to (ie. June 16 to June 17) it will set the start to 5 PM of the day before then run the same duration (instead of June 16 12 AM to June 17 11:59PM it will enter as June 15 at 5 PM to June 16 at 5 PM). Looking at it, the output of the flow should be correct, but it is still entered in SharePoint wrong. Any advice appreciated, screenshots below for reference.

Completed flow input/ output for the add item stepSharepoint Calendar EntryWhole Flow for Reference

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ccc333ab 1,144 on at

Like (0)

Report
Copy link

Link copied!
Did some testing and it appears that the Create Item Start/Date times will get scheduled in UTC time. So I converted the time I would like to make the event for to UTC and it worked.

Here is an example (I put in variables just so you can see it running).
strStartTime I set to June 18
strEndTime I set to June 19th.
I am in the Mountain Time zone.

Of note, without the time zone convert, the event got scheduled at 6:00. Here you can see it is now scheduled at the proper time.

Was this reply helpful? Yes No
djfg 8 on at

Like (0)

Report
Copy link

Link copied!

Appreciate the response! That worked for getting the correct days. Do you know how to set the end time for 11:59 PM on the end day? Otherwise it now shows as ending at 12 AM of the 2nd day. I know there is no way to set all day events with this method so hoping I can do that as a workaround.

Was this reply helpful? Yes No
ccc333ab 1,144 on at

Like (0)

Report
Copy link

Link copied!
How about just subtracting a second off the time, using the expression:
addSeconds(variables('strEndTime'),-1)

Was this reply helpful? Yes No
djfg 8 on at

Like (0)

Report
Copy link

Link copied!

That worked, thanks!

Was this reply helpful? Yes No