Forum Discussion
SharePoint UTC Date conversions - am I missing something here?
Anonymous
Check if the following community post helps you!
Solved: SharePoint Date Data getting changed in Power BI - Microsoft Power BI Community
If not, you can use DateTimeZone.SwitchZone() to convert the timezone. So that way you will not have to create a list and the function will automatically convert it to the expected timezone.
Did I answer your questions? Give a thumbs up and accept this post as solution!
Thanks for your reply.
I have attempted to implement the API V14 call and it appears to be what I am after, but I was still getting some anomalies in the data being displayed. I am not sure, though, whether this is due to a Sharepoint config issue. I also haven't tested when published to the service
I am going to try another list to see how that performs, but I think this is on the right track