Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sharepoint list : Odata vs Connector

I read couple of articles saying the two methods look like the same (odata versus sharepoint connector).  I have one concerned and would love hearing your advices on this :  - I created a dashboard...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    As @ mahoneypat mentioned, SharePoint stores datetime field values in UTC format. When you get datetime from SharePoint, you can use DateTimeZone.ToLocal() function in power query to transform the datetime to your local time to compare it with the OData datatime to check.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

I don't know if this is the case, but one thing to check is if one is returning UTC time (how SharePoint stored datetime info) and the other is returning local time.

Pat

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pat, 

 

This is something I thought about but I have to say I don't know where to check such parameter on sharepoint list. In the field setting I don't see this information but maybe it is somewhere else...? 

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Anonymous ,

    As @ mahoneypat mentioned, SharePoint stores datetime field values in UTC format. When you get datetime from SharePoint, you can use DateTimeZone.ToLocal() function in power query to transform the datetime to your local time to compare it with the OData datatime to check.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.