As we all know there are 3 different types of tables in Powerapps
- 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.
- 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.
- 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 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: