Apps, PowerApps

Set table ownership

As we all know there are 3 different types of tables in Powerapps

  1. Standard Tables – These are OOB tables included in Power platform for each environment. E.g., Business Units, Accounts, Contact. These tables can be customized. Custom tables imported as part of managed solution into specific environment are also Standard tables. These tables can be customized if the Customizable property is set to true.
  2. Managed Tables – These are tables imported as part of managed solution into specific environment. These tables cannot be customized as their Customizable property is set to false.
  3. Custom Tables – These are tables created in the environment directly with custom names. These tables can be customized further. Tables imported as part of unmanaged solution into specific environment are also custom tables. These tables can be customized if the Customizable property is set to true.

Customizing the tables depends on access privilege the user has on the respective table as well.

Table Ownership:

Table ownership is the ownership of records created under this table.

We have User or Team owned / Organization owned types which can be assigned for new tables while creation.

  • User or Team: Data belongs to a user or a team. Actions that can be performed on these rows can be controlled on a user level.
  • Organization: Data belongs to the organization. Access to the data is controlled at the organization level.

Additional table ownership,

  • None: System tables that don’t have any owner, e.g., Privilege table.
  • Business Unit. System tables are business owned. e.g., Business Unit, Calendar, Team, and Security Role tables.

These ownerships cannot be assigned by the user when creating new users.

How to assign table ownership?

Navigate to Table ->Properties->Advanced

Choose the Record ownership drop down as per the screen shot below:

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s