cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
abd3127
Level 8

Date Format while inserting Date And TIme into a sharepoint list

Hello ,

I am having a problem while inserting date and time data in sharepoint list using flow.

I am reading events from my calendar.

So here i get dynamic contents "StartTime" and "EndTime" from sharepoint list in ms flow as this is data read by event trigger from the Calendar event.

here i get correct  time of my event in UTC format. 

Now i want to insert this data in other sharepoint list .

Here when i create a action "Create Item" in new sharepoint list i get the problem.

The UTC time for my event is 9.30  (format of UTC --> 2017-11-24T09:30:00+00:00

But when i inser this data in createe item action i get some other data as output in my sharepoint list column 

(data in SP List -->2017-11-24T01:30:00Z).

Why is this happening and how can i stop this from happening??

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Date Format while inserting Date And TIme into a sharepoint list

Could it be a mismatch between Sharepoint Timezone (Regional/Personal) and the calendar event Timezone?

 

https://sharepointmaven.com/sharepoint-time-zone/





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





7 REPLIES 7
Community Support Team
Community Support Team

Re: Date Format while inserting Date And TIme into a sharepoint list

Hi abd3127,

 

Are you using SharePoint calendar list?


According to your description, it seems that you are using the SharePoint Calendar list, and you are trying to add the item in another SharePoint list within the same site.


So I create a flow likes below to test this issue. When the flow is triggered, the item created in another list has the same End time and Start time with the Calendar list.

3.PNG

4.PNG

5.PNG

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
abd3127
Level 8

Re: Date Format while inserting Date And TIme into a sharepoint list

Hello @v-yamao-msft

i am using outlook calendar and the trigger i am using is "When an event is starting soon".

There i am getting this problem.

Super User
Super User

Re: Date Format while inserting Date And TIme into a sharepoint list

@abd3127

Which value are you receiving in the Trigger output "Start time zone" / "End time zone"?





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





abd3127
Level 8

Re: Date Format while inserting Date And TIme into a sharepoint list

Hi @v-yamao-msft@efialttes

 

I am getting UTC values from the trigger 

Super User
Super User

Re: Date Format while inserting Date And TIme into a sharepoint list

Could it be a mismatch between Sharepoint Timezone (Regional/Personal) and the calendar event Timezone?

 

https://sharepointmaven.com/sharepoint-time-zone/





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





abd3127
Level 8

Re: Date Format while inserting Date And TIme into a sharepoint list

@efialttes@v-yamao-msft

I think its the mismatch. i ll try to correct that.

 

Can u tell mee how to comapre two date time values in Conditions of ms flow?

I needed to check if the two dates match or not ???

Super User
Super User

Re: Date Format while inserting Date And TIme into a sharepoint list

Hi!

THis excelent post explains a method to compare dates thanks to the tick() function

https://flow.microsoft.com/en-us/blog/email-digest-date-manipulations/

Hope this helps

 

 

 





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Users Online
Currently online: 205 members 4,397 guests
Please welcome our newest community members: