How to display more than three columns in Dynamics 365 lookup view.

We know that we can display multiple column in the dynamics 365 lookup view but there is a limitation that you can only display maximum three column in the lookup view, though we can add multiple columns in the lookup view but you can see only first three columns in the lookup view. This is a limitation in Dynamics 365, Microsoft mentioned here.

https://docs.microsoft.com/en-us/dynamics365/customer-engagement/customize/choose-and-configure-columns

Now how to display more than three column value in the lookup. You might be thinking to create a field where if we can store concatenating multiple fields value with some separator and add the field in the lookup view. So now to do this you may need to go for workflow /plugin/JS which is additional work.

Why not we go for calculated field where we can concatenate multiple fields and add the calculated field in the lookup view. I did the same with calculated fields and now I can display more than one field value in my lookup view.

I have created a calculated field (type single line text) in account entity and concatenate few fields with “/” separator which I want to display in the lookup view.

My calculated fields working  fine, see below screenshot.




Now I have added the calculated field in the Account lookup view and do save and publish all customization.

 



 

Now I can see more than three column value in the lookup view.

 

I have also answered similar question in Dynamics CRM Community

 

Hope this helps 😊.

One thought on “How to display more than three columns in Dynamics 365 lookup view.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s