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??
Solved! Go to Solution.
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.
THis excelent post explains a method to compare dates thanks to the tick() function
Hope this helps
Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020.
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Flow Community Video Gallery!