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

Re: SharePoint Calendar Items

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

Re: SharePoint Calendar Items

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

Highlighted
Frequent Visitor

Re: SharePoint Calendar Items

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

Highlighted
Frequent Visitor

Re: SharePoint Calendar Items

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (5,855)