Creating a new column in User Dataverse Table

(2) Share

Report

Posted on by LA-30040116-0

I'd like to create an expiry date column in the User (systemuser) table and allow users to update this field.

But the User = "Write" Isn’t available for the User Table

Could you please guide me on how to achieve this?

Categories:

Dynamics 365 general

Power Platform integration

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Mansi Soni 8,887 Super User 2025 Season 2 on at

Like (4)

Report

Creating a new column in User Dataverse Table

Hello,

As per my understanding, in a model-driven Power App, the systemuser table is a system-managed table in Dataverse that represents users in the environment. While you can add custom columns like an Expiry Date, Microsoft restricts write permissions on this table for most security roles. This means regular users cannot update fields on their own user records, even if custom fields are added.
To manage this scenario, the recommended approach is to create a custom table (e.g., user expiry info) where you can store additional user-related data such as the expiry date. In this table, you would add a lookup column to the systemuser table and then include your custom Expiry Date column. This allows you to fully control permissions—users can create and update their own expiry information without touching the restricted systemuser table.

This solution keeps your app secure, user-friendly, and compliant with platform limitations. It also offers flexibility for future enhancements, such as adding approval workflows or additional metadata related to user access.

Hope this will help you to resolve it!

Regards,
Mansi Soni

Was this reply helpful? Yes No
LA-30040116-0 38 on at

Like (1)

Report

Creating a new column in User Dataverse Table

Hi @Mansi Soni

If I create a new table, would it be possible to change the default link—when clicking on the record owner (e.g.John Doe)—so that it opens the new form instead of the default User form?

Thank you so much for taking the time to read and respond to my question.

Was this reply helpful? Yes No
Verified answer

Mansi Soni 8,887 Super User 2025 Season 2 on at

Like (3)

Report

Creating a new column in User Dataverse Table

Hello,

In model-driven apps, the default behavior when clicking on a user name such as the record owner (e.g., John Doe) is to open the system-managed systemuser form, and unfortunately, this behavior cannot be changed to redirect to a custom table or form. This is because the link is inherently tied to the systemuser table, which is controlled by the platform and not customizable in terms of navigation.

However, a common and effective solution to manage this is to include your custom User Expiry Info table as a related subgrid or quick view form on the sysemuser form. This way, while you can't change the navigation itself, users can still view and interact with the expiry date data directly from the standard user profile. This approach preserves the native behavior while still providing a seamless experience to access and manage your custom data.

Hope this will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
LA-30040116-0 38 on at

Like (0)

Report

Creating a new column in User Dataverse Table

It kind of works, but it's not ideal—the subgrid displays as rows instead of columns. Users could potentially enter multiple records, which they shouldn't.

Using a form control seems like a better solution, though it requires either admin manually entering lookup values or automating the process via Power Automate. I feel like too much of a workaround, so I’ll stick with using only the custom table for now.

Was this reply helpful? Yes No
Mansi Soni 8,887 Super User 2025 Season 2 on at

Like (1)

Report

Creating a new column in User Dataverse Table

Hello @LA-30040116-0,

Please let me know if this meets your needs as outlined.

Regards,
Mansi Soni

Was this reply helpful? Yes No
LA-30040116-0 38 on at

Like (0)

Report

Creating a new column in User Dataverse Table

When I implemented the subgrid, it didn’t provide the best experience for users.

Was this reply helpful? Yes No