Date Format while inserting Date And TIme into a sharepoint list

(0) Share

Report

Posted on by abd3127

320

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??

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

v-yamao-msft on at

Like (0)

Report

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.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
abd3127 320 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

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

Was this reply helpful? Yes No
abd3127 320 on at

Like (0)

Report

Hi @v-yamao-msft @efialttes

I am getting UTC values from the trigger

Was this reply helpful? Yes No
Verified answer

efialttes 14,756 on at

Like (1)

Report

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

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

Was this reply helpful? Yes No
abd3127 320 on at

Like (0)

Report

@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 ???

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (1)

Report

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

Was this reply helpful? Yes No