Your Power Apps user settings are probably wrong
Diesen Beitrag auf Deutsch lesen
Dataverse time zone, date, number and currency settings are personal and environment specific, creating confusing or incorrect values across Power Apps.
TL;DR
Dataverse user settings control time zones and number, currency, date and time formats for each user in each environment. Model-driven Power Apps expose these settings through Personalization settings, while the Power Platform Admin Center cannot change them for another user. XrmToolBox can inspect and update settings, including in bulk.
Original by Jukka Niiranen, on Jukka Niiranen Blog. Read the original
This is our own summary, not a republication or full translation.
Governance takeaway
- Admins/CoE: Document that Dataverse time zone and format settings are environment specific, because users can encounter different values after apps move between environments.
- Makers: Check whether date and time columns need Date Only or Time-Zone Independent behavior, because user time zones can change displayed and stored values.
- Admins/CoE: Use XrmToolBox User Settings Utility when individual or bulk corrections are needed, but plan for repeated work as users and environments are added.
Frequently asked questions
How do I change the time zone and current format in a model-driven Power App?
Open Personalization settings in a model-driven app, then change Time Zone on General and Current Format on Formats. The settings are environment specific.
Can XrmToolBox User Settings Utility update Dataverse settings for multiple users?
Yes. XrmToolBox User Settings Utility can load users, inspect their values, and modify time zone, format, and other settings for selected users in bulk.
When should I use Date Only or Time-Zone Independent Dataverse columns?
Use these column behaviors to avoid certain date and time conversion problems. They do not let end users configure their own personal settings.