Unanswered

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
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

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
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

That worked, thanks!

Was this reply helpful? Yes No