cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CalvinDale
Frequent Visitor

How to display a field other than the primary name field in lookup field’s selection tag

When I create a new record in a related table that has a lookup field, I would like the selected value(s) of the lookup field to display a column value other than the primary name column value for the related table. Is this possible?

 

Here is why I seek to do this. I have a legacy system table that stores GUID and name associations (among other fields). The GUID/name associations are used as a lookup field for a field in another related table. Whereas the GUIDs are permanent, the names associated with the GUIDs occasionally change over time (and are therefore not unique within the table). For this reason, the GUID is the primary name column in the imported table rather than the associated name. When creating a record in the related table (the many side of the relationship), I would like the lookup field to display the name field rather than the GUID field after a selection is made in the selected value tag (i.e., on the create new form for the entity on the many side of the relationship). The display value for the tag (button? or label?) evidently is not affected by the lookup view design. Hence, I wonder if this is even possible. If so, it would improve the user experience.

5 REPLIES 5
v-xiaochen-msft
Community Support
Community Support

Hi @CalvinDale ,

 

Did you use Canvas app ?

If you use the canvas app and you want to show a certain column to the user, I suggest you use the combo box control.

 

I assume I have a table 'Test 77S' . It has a lookup column 'TestLookup'. Its related table is 'Test 66S'.

 

Please refer to the steps below:

1\ Set Items property of combo box control to:

 

Choices('Test 77S'.TestLookup)

 

 

2\ Set other properties of combo box control like pictrue:

v-xiaochen-msft_0-1616119807153.png

// You could choose the columns you want to display

 

In addition, If you do not use the canvas app, you can modify 'view'.

v-xiaochen-msft_4-1616120768322.png

 

v-xiaochen-msft_3-1616120737265.png

 

// Assuming that 'Test3' column is shown to the user, please set it as shown in the figure above.

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

 

 

CalvinDale
Frequent Visitor

Hello and thanks for the response. Actually, it is a model-driven app.

v-xiaochen-msft
Community Support
Community Support

Hi @CalvinDale ,

 

So, I considered this situation.

Please try the second solution I mentioned above and tell me if it works for you.

 

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Thanks. Your second solution is also applicable to a canvas app and is not applicable to a model-driven app.

TB
Regular Visitor

Hi Calvin Dale,
Did you able to find a solution for this in Model Driven App? 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,017)