Answered

Patch or Collect UTC Time Zone

(0) Share

Report

Posted on by loraDallas

We have an Azure database that is based on UTC time zone. We also have users from 5 different time zones all over the world working and patching data from Powerapps to that database.

The Now() function patches the local time zone from user's laptop which is unmanageable. We want to patch the UTC time zone which will be patched to a datetime column so converting to text is not an option.

Any help is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sundeep_Malik 6,486 on at

Like (0)

Report
Copy link

Link copied!

Hey @loraDallas

By the following formula you would be able to get the time in utc. Then you can just patch it in your database.

Text(Now(),DateTimeFormat.UTC)

I hope this helps. 🙂

If I answered your question, you can accept it as the solution. And also give thumbs up. 🙂

Was this reply helpful? Yes No
loraDallas 42 on at

Like (0)

Report
Copy link

Link copied!

Hello @Sundeep_Malik ,

Thank you for your reply, but the database column in table is a datetime field and cannot patch a text string to this field.

Was this reply helpful? Yes No
loraDallas 42 on at

Like (0)

Report
Copy link

Link copied!

Hello @Sundeep_Malik ,

Thank you for your reply, but the database column in table is a datetime field and cannot patch a text string to this field.

Was this reply helpful? Yes No
Verified answer

Sundeep_Malik 6,486 on at

Like (0)

Report
Copy link

Link copied!

@loraDallas

Check this blog, if it helps:

https://powerapps.microsoft.com/gl-es/blog/working-with-datetime-values-in-sql/

Was this reply helpful? Yes No
Verified answer

loraDallas 42 on at

Like (0)

Report
Copy link

Link copied!

Ending up finding the following code:

DateAdd( Now(), TimeZoneOffset(), Minutes ) which converts any local time to UTC.

Was this reply helpful? Yes No