Is there any option to show on the lookup field more than 3 first columns from the lookup view?
*This post is locked for comments
Is there any option to show on the lookup field more than 3 first columns from the lookup view?
*This post is locked for comments
Yes ,this is a limitation of calculated field. Calculate field does not allow lookup field to concatenate. How many lookup field you want to concatenate ? if its one or two then you can add directly in the lookup view. For others fields you can use inside calculated field.
Thank you for this solution. Whether the combined fields must be in the text format? Because when I am trying to concatenate the lookup and list fields I am getting an error with calculation.
Hi ,
Another workaround would be creating calculated field where you can concatenate multiple fields with separator and add the calculated fields in the lookup view . See here its working for me -
Here I have created a calculated field and concatenate following fields for account-
Added the fields in the lookup field , see the result -
I would suggest to go with this idea , just need to create a field.
I wrote a blog for the same -
Hi ,
Workaround would be create separate fields where you can store two or more fields concatenate value (use some separator while concatenate using plugin or workflow in create and update event ) which you want to show .
Unfortunately this is a product limitation. Only first 3 fields will be displayed in lookup view.
"When you add columns to Lookup views for updated entities, only the first three columns will be displayed."
Read the Note: docs.microsoft.com/.../choose-and-configure-columns
André Arnaud de Cal...
292,516
Super User 2025 Season 1
Martin Dráb
231,436
Most Valuable Professional
nmaenpaa
101,156