Display Timezone - SharePoint List Modified Date

[luvagoldenk9]

Hello,

I have a Power App that is editable by people in the various NA time zones. The source data is a Share Point list so that the record's modified date/time is captured in the column 'Modified'. We want to show the modified information as:

"Last modified by Joe Smith on 2/18/21 8:37AM XXX"

where XXX is the timezone corresponds to the timezone that the associate did the update in. So if Joe is Mountain Standard Time (MST) the 'XXX' would be 'MST'. 

Is this possible to determine and display in the Power App?

Thank you in advance for your assistance!

[WarrenBelz · Accepted solution]

Hi @luvagoldenk9 ,

You need the TimeZoneOffset function, which returns the difference between UTC and the user's device. YOu could then determine what time zone they are in.

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.

[luvagoldenk9]

@WarrenBelz Thank you for sharing that function. It worked perfectly for what I needed. Have a great day!