Add A space between 2 combobox displayfields items

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone,

I have a combobox and it has a table as DisplayFields property : ["cref8_firstname","cref8_lastname"]

This gives me as options (example):

JaneDoe
JoSmarts
EllenVivs

However i would like it to have a space in between the firstname and lastname. This would give me:

Jane Doe
Jo Smarts
Ellen Vivs

I tried a few things:

["cref8_firstname"," ","cref8_lastname"]
["cref8_firstname& " "&cref8_lastname"]
I also tried concating etc but nothing really worked

Anyone knows how to do this simple magic?

Kind regards,

Anthony

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Irfan 164 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AnthonyDo

I dont believe you can achieve that directly through ComboBox.

You will need to have a custom column which stores your concatenated values.

Eg: In my case, I had a collection called as coll_Owner. I am using columns Owner and Num from the collection.

Now if I want to use a ComboBox to show me "Owner Num" in a single row in combobox, I'll need to create another collection which stores the concatenated values
ClearCollect(collFinallist,AddColumns(coll_Owner,"Owner + Value",Concatenate(Owner, " ", Num)))

ComboBox
Use collFinallist as my datasource for my combobox.

Either you can add column to your collection OR you can add extra column to your datasource which will hold the concatenated values.

Bit of a pain but I dont believe there is an easy way out of this 🙂

Hope it helps.

-Irfan
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

How is the data in the column structure? Because that determines whether the names are joined or not.

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

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.
runner9207 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Could you elaborate on this more? I have a table with a lookup field in Microsoft Dataverse and am running into this same issue. What do I need to adjust in the table so that the data pulled from the columns doesn't join?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
I fixed it this way:

First i made a collection with all the records in it. Then i made another collection and added a column that concatenates the first and lastname. I did that in the onvisible of my home screen. You could do this on onstart of your app aswell or however you like.

Onvisible Homescreen:

Collect( colEmployeeTrainingDropdown, galEmployees.AllItems ); Collect( colEmployeeTrainingDropdown2, AddColumns( colEmployeeTrainingDropdown, "Name", Concatenate( 'First Name', " ", 'Last Name' ) ) )

Then for the dropdown you use the following formulas:

Items: colEmployeeTrainingDropdown2
DisplayFields: ["Name"]

Kind regards,

Anthony