Power Platform Community Forum Thread Details

I am sure this is a simple fix, but I am missing something.

I have a button that patches both a SharePoint list as well as an Excel file using the Now() function.

The SharePoint data is the current date and current system time, but Excel is being reported as UTC.

I have tried DateDiff(), TimeZoneOffset(), but I cannot seem to get the data inserted into Excel as needed in the current timezone format.

Thanks for any guidance.

Cheers

Categories:

General Questions

Hello @Hack-7,

You need to use a combination of DateAdd and TimeZoneOffSet. You can read about it in the official documentation in the section converting from UTC. As excel by default will be parsed for UTC you need to apply a formula DateAdd( yourdatetime, −TimeZoneOffset( yourdatetime ), TimeUnit.Minutes )

Here is the official documentation DateAdd, DateDiff, and TimeZoneOffset functions - Power Platform | Microsoft Learn

Hope this helps clarify the doubt, let me know in case you're still facing an issue within it.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.