Forum Discussion

number8wire's avatar
number8wire
Copper Contributor
May 17, 2024

Display local time for users in a Sharepoint List

Hi,

I want to display the local time for each user in a Sharepoint list of users. I want this to dynamically change when the page is refreshed.

I can store the UTC time difference for each user within the list using a Power Automate flow, as this does not change (store this in a "UTC Diff" column.

What I need is to know the current user's UTC time difference so that I can can calculate the local time for all the other users based on the @now component in the JSON column format.

e.g. if the current user is 12 hours ahead of UTC and a user in the list is 4 hours behind UTC I can calculate that user's local time as "=@now-12-[$UTC Diff]" in the JSON formatting.

Is there any way within the JSON formatting to get the current user's localisation data to detect the timezone of the current user so I can detect the UTC difference (12 in the example above)?

Thanks for your help in advance!

No RepliesBe the first to reply

Resources