Add a table as a lookup option in your app

Lookup functionality

With model-driven apps, for a table to be available in a lookup it must be added to the app. For example, contact records have the ability to be assigned to a user or a team. Both of these tables have a relationship with the contacts table.

Entity lookup with both users and teams available.

However, if the User table is included in the app but the Team table is not, only user rows will appear in a lookup.

Entity lookup with users only.

This can be resolved by adding the Team table to the app using the App Designer.

  1. Go to Power Apps, and then select Solutions.

  2. Open the solution you want, and then select the model-driven app. This opens the app in the app designer.

  3. Select the Components tab, select Entities (tables), and then select Team.

    Add the team table to the app.

  4. Select Save, and then select Publish to make the change available to app users within the organization.

Next Steps

Share a model driven app