Event in Outlook from a SharePoint list does not allow Start/End Time

(0) Share

Report

Posted on by Tclark7

Objective: When adding a new item to a SharePoint list an email is sent to the owner with the details and an event is added to the Outlook team calendar.

Outcome: The email is sent with the details to the owner but the format of the start time and end time in Power Automate is yyyy-mm-ddT00:00:00. In the SharePoint form the date is mm-dd-yyyy so when I try to use data from the form I get a 400 error. If I manually type the date it works but it puts the calendar item at midnight where it can't be seen. If I try to add the time it covers up the rest of the items on the calendar.

There is a an option to add advanced parameters and one of them is an all day event but when you select all day event it completely removes the item from the calendar. Also if you select an advance option of a show as free on the calendar it doesn't work either.

What I need is for the SharePoint form to supply the date without blowing up the flow with errors.

Screenshot 2026-0...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Using flows

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

rzaneti 4,476 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TC-15011530-0,

Assuming that you always want the event to start at midnight, try to use this expression: startOfDay([date_from_sharepoint]), and make sure to populate the Timezone input, in the Create event action.

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
Tclark7 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @rzaneti,

This is my first flow so I'm learning. The error says the string was not recognized. I put your string in the Start time section. Isn't there something needed in the End Time section as well?

Was this reply helpful? Yes No
Tclark7 6 on at

Like
a
(0)

Report
Copy link

Link copied!

This is my first flow so I'm learning. The error says the string was not recognized. I put your string in the Start time section. Isn't there something needed in the End Time section as well?

Was this reply helpful? Yes No
Suggested answer

rzaneti 4,476 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Tclark7,

Welcome to the Power Automate world! I'm including some links to some blogs related to the topics discussed during this response, so you can access it if you need further reference :) By the way, feel free to ask for clarification about any step recommended here.

First of all, could you please share an image of your flow design in the body of the message? I know that you already attached an image to your question, but unfortunately this forum takes too long to process the attachments, so I still don't have access to it.

In addition to that, please also share the raw outputs (instructions here, if you don't know how to do it) of your Get items from SharePoint, containing the values of the Date column that you want to use as input for creating the event. Make sure to remove any sensitive data from the image before posting it :)

About the End time, yes, you should also include something in this input. Assuming that you just need the event in your calendar, independent on the start/end time, my recommendation is to use the following date/time expression: addHours(startOfDay([date_from_sharepoint]), 1). You just have to replace the text highlighted in yellow by the dynamic content of your SharePoint column.

Since you're new to the platform, just want to give you some context: the expression recommended in my previous message will simply take any timestamp (a text representation of a date/time) and set it to the exact first moment of the day (midnight). The expression of the current message is pretty much the same, but it includes another function (addHours), which will take this first moment of the day and add 1 hour to it, making 1AM of your SharePoint column's date. This strategy ensures that the events created by the flow will always start at midnight and end by 1AM.

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
Tclark7 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@rzaneti,

I really appreciate you taking the time to help here. Your responses have been helpful. Is there a site that lists all the commands available in Power? I"m including the image of flow and raw output. The first one is the raw output and the last one is the raw input.

Was this reply helpful? Yes No
Tclark7 6 on at

Like
a
(1)

Report
Copy link

Link copied!

@rzaneti,

Thank you for all your help. I was able to figure out what I was doing wrong. I will continue to check out all of your references.

Was this reply helpful? Yes No