Forum Discussion
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!