Set up security permissions for a column

There are two steps to set up security permissions for a column.

  1. Allow column security on one or more columns for a given table.

  2. Associate one more existing security profiles, or create one or more new security profiles to grant the appropriate access to specific users or teams.

After you create the profile, you assign users and or teams to that profile, and set up specific read, create, or write permissions for the column.

More information: Security concepts

Note

The use of table-related terminology depends on the protocol or class library used. Learn more in Terminology use depending on protocol or technology.

Enable column security

  1. Sign in to Power Apps.

  2. Select Dataverse > Tables.

  3. Select a table.

    Screenshot showing where to select the Contact table.

  4. Under Schema, select Columns.

    Screenshot showing where to select Columns.

  5. In the Columns list, select a column.

    Screenshot showing how to select the Mobile Phone column.

  6. Expand Advanced options, and then under General, select Enable column security.

    Screenshot showing how to expand Advanced options and turn on column security.

  7. Select Save.

Associate security profiles and set permissions

  1. Sign in to the Power Platform admin center with System Administrator security role or equivalent permissions.

  2. Select the environment to configure security profiles for.

  3. Select Settings > Users + permissions > Column security profiles.

  4. Select an existing profile, or select New Profile, enter a name, enter a description, and then select Save.

  5. Select the Users tab, select + Add Users, select the users that you want to control access, and then select Add.

    Tip

    Instead of adding each user, create one or more teams that include all users that you want to control access.

  6. Select the Column Permission tab, in the Name column select one or more columns, and then select Edit. Configure the three columns for the desired access.

    Screenshot showing the Edit column security permissions.

  7. Select Save.

Any users not defined in the previously created column security profiles won't have access to the mobile phone column on contact forms or views. The column value displays Lock icon. ********, indicating that the column is secured.

Column-level security to control access
Enable or disable security for a column to control access