cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arnonel
Helper IV
Helper IV

Forms, Lookups, Dropdownlists

Capture.PNG

 

Hi 

 

See above. 

I have a form. Form has a dropdown list due to field being a lookup to "Client" Entity (Client Entity has 2 fields: ClientID, and ClientName. ClientID is the "Title" field)

 

The displaytext is the ID - how can I change the dropdownlist display text to be "ClientName", instead of the current "ClientID" ?

60 REPLIES 60
hpkeong
Community Champion
Community Champion

Hi

To make the Dropdown in data are with the text you want, you can always define yourself.
Item = ["A", "B",...], and then set correspondence value bu referring to another entities using Dropdown.OnChange or OnSelect.

I guess this is easy for you as long as you link all those together.

If I am still not replying to your needs, why not you snap shot or sketch with simple table, layout,..of what you wish to accomplish and surely in the forum,they are many of us can try to share our ideas to help.

Have a nice day and goodnight from Malaysia.
hpkeong

I have the following entities

  • Client Contact:
    • ClientContactID: number sequence (title)
    • ClientFullname: Text
    • Client: Lookup (Client below)
  • Client:
    • ClientID: number sequence  (title)
    • ClientName: Text

 

I want to create an edit form for Client Contact, so I:

  • Create new screen
  • Throw a form on it
  • Set data source to "Client Contact" entity above
  • Enable the following datacards:
    • ClientFullname
    • Client
      • When doing this, i choose "edit lookup"
      • Values displayed are "ClientID" - but I want it to display "ClientName"

 

 

As above. I think this is a common/simple use case for related entities / lookups. 

 

So what I want is:

  • Ability to use forms
  • No workarounds
  • Dropdownlist for lookup which shows "ClientName" column, instead of the entity title field, which is "ClientID"
rgruian
Power Apps
Power Apps

 

Please select the card that contains your lookup field dropdown. Then on the right hand side pane under "Form Customization", spot your field, and click the "..." icon, and change the "Value" dropdown to ClientName. This will change the projection of that lookup field (which is a complex object in PowerApps) in the dropdown. The card will continue to see the entire complex field value underneath, but only the Client Name will be rendered.

 

I hope this helps.

 

 

Radu Gruian [MSFT] ** PowerApps Staff
Perumal
Continued Contributor
Continued Contributor

I have tried it, in the value dropdown, "Title" alone is displayed.

powerapps.png

Its greyed out, and defaults to ClientID.  No way of changing, hence this thread. 

Capture.PNG

 

Sorry for the insistence here, but I just want to make sure we are not missing something obvious.

 

I understand that the Value dropdown looks greyed out. However, styling side, are you sure it is disabled? Have you tried clicking on the dropdown to see if there are any other fields available?

 

Also, is Client Name a required field in the referenced list, or is it optional?

 

 

Radu Gruian [MSFT] ** PowerApps Staff
Perumal
Continued Contributor
Continued Contributor

I have rechecked in the styling side, in the drop down, title alone is displayed. Also the ClientName is a required field in the refrenced list.

 

powerapps.png

I have a Sql Server database with a couple hundred entities but I'm only interested in 50 or 60 at the moment.  I have a need for 30 or 40 Lookups implemented with DropDown's which in the database are linked through foreign keys and 1:n reationships and I need a way to easily define these on a number of forms.

 

I have worked on LOB apps for 20 years across a range of industries and large companies and such a requirement is very, very common. In fact this requirement is on the small side so I am concerned with the earlier response describing 50 entities and 100 lookups as huge and complicated. 

 

Such a response is indicative of PowerApps being designed only for tiny data models and therefore unsuitable for real LOB apps.

 

So, what's the deal with PowerApps - is it meant for real LOB apps or tiny demoware?  Since the market and need for the former is huge I really hope that is where PowerApps is targeted...

 

@rgruian - see attached photos - the "Value" dropdown only shows "ClientID"

 

Capture.PNGCapture2.PNG

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,232)