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

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

@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!
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

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.