Is it possible to display more than two fields in a combo box

(0) Share

Report

Posted on by cfebvre

232

Hi all,

As stated in the title, is it possible to display more than two fields in a combo box?

It appears not to be possible, I've tried manually editing the 'DisplayFields' property and adding a third Sharepoint Column but this does nothing.

Screenshot 2020-10-30 102301.jpg

I know there is one workaround, which is to use and AddColumns() Function in the items property, then Concatenate two or more columns, then select that new combined column in the 'Fields) property of the combo box - however this seems to cause a Delegation problem. (PowerApps does not display the usual warning, however my filtered choices in the ComboBox are incomplete so I assume this is what is happening).

Doe sanyone know of a different method that does not create a delegation problem?

Cheers in advance.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @cfebvre ,

Not as separate items, but you could use AddColumns() to your query and concatenate the extra columns, then display the new field.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
cfebvre 232 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz ,

Yeah, I'm aware of that workaround and have tested it out, as original post, but it appears to create a delegation issue when I then filter that new concatenated column. (no warning triangle, or blue underscore, but the list of choices is incomplete).

It's as I suspected, don't think it can be done - at least not for the use I need it for.

I'll mark you as an accepted solution though so people searching for this can find it - might be of use to others.

For me, I think rather than combo box, I might try a 'pop out' gallery instead, and users can select a required item from that gallery, then I'll get it to do the hocus pocus I need it to on Select.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Thanks @cfebvre ,

I actually use galleries that for this purpose quite often - you can make the user experience similar to a combo box with a lot more flexibility.
Zameer 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes,
as i need to display more than 2 fields in comboBox,
For this i created one more property in my EntityModelClass.cs.
Ex:
[NotMapped]
public string DisplayName {
get
{
return string.Format($"{ecName} {ecProgram} {ecAcademicYear} {ecSemester}");
}
}

Then in XYZForm.cs class set ComboBox's Value Member and DisplayMember properties and then fetch data from Database and copy in ComboBox.DataSource property as follows .

Ex:
cbInstitute.ValueMember = "ecID"; //This is my database table ID primary key, which i'm setting as a value for comboBox.
cbInstitute.DisplayMember = "DisplayName"; //defined above property in EntityModelClass.cs class.
cbInstitue.DataSource = context.EntityModelClass.ToList();
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@cfebvre Can you please give the example formula. I have the same requirement where I have to display in the dropdown Person Name, EmployeeId, Vaccine status and Booster status