Forum Discussion
Timezones for existing entries
I have a requirement to find out what timezeone a user was in when they submitted an item to a sharepoint list - items were added to the list via a mobile powerapp there was no feature in the app at ...
Hi DL2024,
If the timezone wasn’t captured when the items were submitted, it’s tricky to determine the timezone a user was in at that time. SharePoint records dates and times in UTC, but without specific timezone data from the mobile PowerApp, there's no direct way to retroactively identify the timezone for each entry.
Here are a couple of suggestions you might consider:
Ask Users: If possible, reach out to users who submitted the entries to gather their timezones, especially if the submissions were made around a specific timeframe.
Add Timezone Tracking: For future submissions, consider updating your PowerApp to include a field for users to select their timezone. This way, you can track it moving forward.
Review Patterns: If you have historical data, you might analyze submission times to infer patterns based on known timezone differences, but this would be less accurate.
I hope this helps clarify things!
Reach out for further assistance with sharepoint
Best,
Olaide
If the timezone wasn’t captured when the items were submitted, it’s tricky to determine the timezone a user was in at that time. SharePoint records dates and times in UTC, but without specific timezone data from the mobile PowerApp, there's no direct way to retroactively identify the timezone for each entry.
Here are a couple of suggestions you might consider:
Ask Users: If possible, reach out to users who submitted the entries to gather their timezones, especially if the submissions were made around a specific timeframe.
Add Timezone Tracking: For future submissions, consider updating your PowerApp to include a field for users to select their timezone. This way, you can track it moving forward.
Review Patterns: If you have historical data, you might analyze submission times to infer patterns based on known timezone differences, but this would be less accurate.
I hope this helps clarify things!
Reach out for further assistance with sharepoint
Best,
Olaide