How to display DataVerse Lookup as Dropdown in canvas apps

Hello everyone and welcome to my blog. In today’s blog I will discuss on how to display a lookup column of DataVerse as a Dropdown in Power Apps canvas apps.

Account has a contact lookup field – Primary Contact. The field is usually required to store the primary contact for a customer. For our demo, we will use this lookup field.

I want to show this field as a dropdown in my canvas apps. Users should be able to select a contact record from the dropdown. To do that, I insert a Combobox control on my screen. And then set it’s Items property to the following formula.

primarycontactid is the logical name of the Primary contact field.

The next step is to set up the display column values in the combobox. For this, select your Combobox and then click on Edit on the right pane. You can then choose the template for the combobox display – whether a Single column layout or a Double column layout.

If you want to show a single field of the contact to the user, example – only the first name or last name, you can choose Single Layout.

In my case I wanted to display couple of field information from the contact entity. So I chose the Double template layout.

Choose your Primary and Secondary text fields and your Search Field depending on your requirement.

All set and done, when you run the application you can now select a Contact record from the Dropdown.

In the below screenshot I am searching for the contact Nancy and it shows up. Since I selected Double layout, I can see both the the fullname and the last name.

That concludes this post. Hope you liked the post. If this post has helped you, you can buy me a coffee.

To stay updated with more such tips on Microsoft.NET and Power Platform, please subscribe to my blog. Link to subscribe on the right pane.

You can also check out the below posts.

Debajit Dutta
Business Solutions MVP