Lookup field only shows one column

(0) Share

Report

Posted on by Community Member

Hi everyone,

I've encountered a peculiar situation this morning. In one of our development instance, the lookup dropdown only shows one column from the lookup view.

6862.Screenshot_5F00_4.png

Normally it will show 3 columns like so:

2055.Screenshot_5F00_5.png

Any idea what might have caused this?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi ,

Please check lookup VIEW of the lookup entity how many columns are defined. You can add remove columns as per your needs by editing lookup view of the entity.

ledgeviewpartners.com/.../customize-lookup-views-in-dynamics-crm

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report
Copy link

Link copied!

Hi Alvin,

Looks like someone has messed up with the lookup view of this unit entity.

navigate to settings > customizations > customize the system > Entity > unit entity > views > look for lookup view and add required columns again.

publish all your customizations and see if that works.

Was this reply helpful? Yes No
Suggested answer

Pawar Pravin 5,237 on at

Like (0)

Report
Copy link

Link copied!

Hi Alvin Budiman,

It looks like someone has removed remaining column in lookup view. Can you please check lookup view on production instance.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Goutam, Rawish, and Pravin.

Thank you for your responses.

I have checked the lookup view and the columns are still there.

I have also made sure that this is the lookup view used by the field.

In fact the 2 screenshots in my original question share the same customization. It's just the first one is on the upper layer instance where we make additional customization on top of the bottom's instance.

Any further ideas are appreciated.

Thanks!

Was this reply helpful? Yes No
Suggested answer

gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi ,

Can you please put one single line text field (Make sure the field value available ) in the second position of the view and do publish all customization.

Was this reply helpful? Yes No
Suggested answer

Rawish Kumar 13,758 on at

Like (0)

Report
Copy link

Link copied!

That looks strange!

few things you can try:

1. try to publish the customizations again and clear the browser cache and see again.

2. export this view from an environment where it is working and import to this environment and publish.

3. finally you can look into the customization xml of this view to see if in the xml these all columns are available.

Was this reply helpful? Yes No
naZir 850 on at

Like (0)

Report
Copy link

Link copied!

Hi Alvin,

Did you check for that effected look up contained records have all the field values. In Look up it shows next 3 field values in a row .

Regards,

Nazir

Was this reply helpful? Yes No
Suggested answer

Alok Singh 910 on at

Like (0)

Report
Copy link

Link copied!

Hi Alvin,

Could you please check the view used for lookup as sometime we use custom view in lookup and then validate the columns of the views. Ideally first 3 columns of view used in lookup will be displayed for entity.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi everyone, thanks for the response.

I have checked your suggestions and there is no irregularity in the customization that might cause this. However, I accidentally found the fix.

In the form editor, if you open the lookup field properties, you can select the lookup view to be displayed by the lookup field.

What I did was I selected another default view, save, publish. After I did that, the lookup field shows 3 columns normally. I change back to the originally selected lookup view, save, and publish. Lo and behold, the lookup still shows 3 columns. This is the screenshot of the problematic instance after I applied that 'fix'.

It's all working as intended now.

Thank you for your responses guys, I really appreciate your time.

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Please close the thread , which may helps others in future .

Was this reply helpful? Yes No