Define alternate keys using Power Apps
Power Apps provides an easy way to view and create table alternate keys with the Microsoft Dataverse. For more information about alternate keys, see Define alternate keys to reference rows.
Power Apps enables configuring the most common options, but certain options can only be set using solution explorer. More information: Define alternate keys using solution explorer
Important
If the data within a column that is used in an alternate key will contain one of the following characters /, #,<,>,*,%,&,:,\\,?,+ then GET or PATCH actions will not work. If you only need uniqueness then this approach will work, but if you need to use these keys as part of data integration then it is best to create the key on columns that won't have data with those characters.
View alternate keys
- In Power Apps (make.powerapps.com), select Tables from the left navigation pane, and then select the table that you want to view. If the item isn’t in the side panel pane, select …More and then select the item you want.
- Select Keys to view a list of any alternate keys that are defined.
Create an alternate key
While viewing alternate keys, select New key.
Use the panel to set a Display name and choose the columns to use to create the alternate key.
The Name column will be populated based on the display name.
Select Done to close the panel.
Select Save table to create the alternate key.
Note
The alternate key will not be immediately available. A system job is initiated when you save the table to create database indexes to support the alternate key.
Delete an alternate key
While viewing alternate keys, select the key you want to delete and choose Delete Key from the command bar.