web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Lookup field as a comb...

Power Apps

Answered

Lookup field as a combo box issue

(0) Share

Report

Report

Posted on by PrashantIyer

23

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

Powerapp query 0.PNG

Powerapp query 1.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No

Join the conversation