cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rob_CTL
Level: Powered On

Create Event - How to create an all day event in Outlook from SharePoint list date column?

Hi,

 

I am trying to add an all day event into an Outlook calendar based on a single date column within a SharePoint list.  The issue I am having is that the "Create Event v2" connector has specified both the "Start Date" and "End Date" as mandatory.  In these fields I am using the dynamic content to pull the date from the SharePoint list.  However the Flow fails because there is not 24 hours between both the Start and End date.

 

datafail.jpg

 

Is there a way I can spoof the start/end dates so that they appear to be 24 hours apart?

 

Thanks

Rob

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Create Event - How to create an all day event in Outlook from SharePoint list date column?

Hi @Rob_CTL,

 

I have made a test on my side and have created a "EndDate" column in the sharepoint list.

Please refer to screenshot below to createthe flow:

Capture.PNG

 

The expression in the End time field of the "Create event(V2)" action as below:

addSeconds(triggerBody()?['EndDate'],2)

The flow would run successfully as below:

Capture.PNG

 

 

Best regards,

Alice

 

 

 

 

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Create Event - How to create an all day event in Outlook from SharePoint list date column?

This works for me...

I am using the created date as a proxy for your date column.

Here is what I used for the start time:

startOfDay(triggerBody()?['Created'])
 
Here is what I used for the End Time
addHours(startOfDay(triggerBody()?['Created']),24)
 
I have all day event set to yes.
 
My Flow using the above settings worked without error and created an all day event.
 
If this solves your issue, please mark your post as Solved.
 
Scott
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Community Support Team
Community Support Team

Re: Create Event - How to create an all day event in Outlook from SharePoint list date column?

Hi @Rob_CTL,

 

I have made a test on my side and have created a "EndDate" column in the sharepoint list.

Please refer to screenshot below to createthe flow:

Capture.PNG

 

The expression in the End time field of the "Create event(V2)" action as below:

addSeconds(triggerBody()?['EndDate'],2)

The flow would run successfully as below:

Capture.PNG

 

 

Best regards,

Alice

 

 

 

 

View solution in original post

Super User
Super User

Re: Create Event - How to create an all day event in Outlook from SharePoint list date column?

@v-yuazh-msft - much better idea than mine 🙂

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Rob_CTL
Level: Powered On

Re: Create Event - How to create an all day event in Outlook from SharePoint list date column?

Thanks @v-yuazh-msft

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,577)