Lookup field as a combo box issue

[PrashantIyer]

Hello guys,

I have a custom entity "Business Interest" and a lookup field on the Opportunity entity "Main Business Interest" on this custom entity. I have an edit form on the Opportunity entity with several fields including this lookup field.

When I try to select a Business Interest from the combo box, it instead shows me the list of Opportunities instead. Is there a way to display the records of the custom entity instead of the Opportunities?

TIA

[eka24]

You did not display the Items on the Combobox:
Can you display the lookUp Formula

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[v-xida-msft · Accepted solution]

Hi @PrashantIyer ,

Is the "Main Business Interest" field a LookUp type field in your Opportunities Entity, which reference values from the "Business Interest" Entity?

Could you please show more details about the Items formula within your "Main Business Interest" ComboBox?

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Please make sure you have specify proper formula within the Items property of the "Main Business Interest" ComboBox:

Set the Items property of the "Main Business Interest" ComboBox to following:

Choices(Opportunities.'Main Business Interest')

then specify proper column name as display column value within this ComboBox:

Also please go to your Opportunities Entity, then check if the "Main Business Interest" LookUp field is bind to your custom Entity "Business Interest" properly:

Best regards,