Answered

Form Card ComboBox - combine two fields in displayfields?

(0) Share

Report

Posted on by Medoomi

523

I have a form which pulls data from a CDS entity. Within that form, one Card pulls data from a lookup field, and as such was created (by default) as a ComboBox. Unfortunately this field draws from an entity which has names split into first and last.

I would like to populate the ComboBox with both first and last within its dropdown? Is there a way to do this?

At present the DisplayFields contains: ["cr6a2_firstname"]

And the SearchFields contains: ["cr6a2_firstname"]

I have tried ["cr6a2_firstname" & " " & "cr6a2_lastname"], but the syntax is wrong & I'm not sure how to correct it.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

eka24 20,923 on at

Like (1)

Report

Use:
["cr6a2_firstname", "cr6a2_lastname"]

------------

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
Medoomi 523 on at

Like (0)

Report

@eka24
Thanks so much for your reply.
I put ["cr6a2_firstname", "cr6a2_lastname"] in both DisplayFields as well as SearchFields & I can now search by both last as well as first name, but the display name only displays the first name.
Is there another location I need to edit to have the ComboBox display both names?
Thx!

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (1)

Report

It depends whether you have a single field or Double field in the combobox (See Screen shot). There are two ways to change it:

If you have a Double field:
Select the Combobox and on the DisplayField property: ["cr6a2_firstname", "cr6a2_lastname"]

If you have a single field you need to add a secondary field, thus change it to Double (Click on the combobox and on the right pane property, select Field Edit:

Sample single
Learn more on combobox:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-combo-box

------------

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