Add a table as a lookup option in your app
This article describes a feature that uses the classic app designer.
Important
Starting in October 2023, the classic app, form, and view designers are deprecated and all model-driven apps, forms, and views only open in the modern designers. By default, the Switch to classic command to revert back to the classic designer from the modern designer is no longer available. More information: Classic app, form, and view designers are deprecated
We recommend that you transition to use the modern designers to create and edit your model-driven apps and components.
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.
However, if the User table is included in the app but the Team table isn't, only user rows appear in a lookup.
This can be resolved by adding the Team table to the app using the app designer.
Add a related table to an app to enable the lookup
Go to Power Apps, and then select Solutions. If the item isn’t in the side panel pane, select …More and then select the item you want.
Open the solution you want, and then select the model-driven app. This opens the app in the app designer.
Select the Components tab, select Entities (tables), and then select Team.
Select Save, and then select Publish to make the change available to app users within the organization.