cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

SharePoint Calendar Items

I got a SharePoint Online (O365) List that is a Calendar to work in a Flow.  I have an approval list that then enters data from the request list into the Calendar list.  When setting up, I used SharePoint - Create Item Flow activity and had to manually type in the List Name once paste in the URL of the SharePoint Online site (10/25/16 confirmed working).

 

However, not all the fields are available - for example, the All Day Event field is missing, but Event Type (used for recurring events, normally a hidden Calendar column) is visible.  As an alternate method, I tried to then create another action of SharePoint - Update Item but the All Day Event field is still missing.

 

The odd thing on Date/Time fields is that I am pulling a Date Only (no Time) from a SharePoint List submission and then using that as the Date entry in a SharePoint Calendar (once the Flow is approved).  The Date Only comes into the Calendar List as Date at 12:00 AM (midnight).  So when using a Date Range of 3 days, it comes into the calendar as Midnight of Day 1 to Midnight of Day 3 - thus only blocking out 2 days on calendar. 

 

Through trial and error, I played with a formula in the End Date in Flow using + # and - # to determine that [End Date] - 31 somehow works (for the most part)... that is very strange.  But if the All Day Event column was available to just enter YES, I believe it would come in as 3 day event.

 

Thanks,

Bill C

4 REPLIES 4
Highlighted
Frequent Visitor

I need the same thing

I cannot find the way to set the all day event in the calendar item in sharepoint

thanks

Arturo

Highlighted
Advocate I
Advocate I

I'm having the same issues.  Any updates on this?  Thanks!

Highlighted
Frequent Visitor

I'm also looking for the same option, how to add a calendar event as an all-day event.

Advocate I
Advocate I

I also need to be able to set the all day event field in Flow/Power Automate.  When copying calendar items between two SharePoint calendars, all day events go into the destination calendar offset by UTC so in the Eastern time zone, all day events are copied to the destination calendar spanning two days with start times of 7:00 PM the day before the event until 7:00 PM on the day of the event.  I could probably correct this in Flow if I could manipulate the all day event field (then update the start and end times to account for UTC offset).  Highly frustrating!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (8,688)