Populate combobox with the text from multiple labels

(0) Share

Report

Posted on by catalinaA

Hello,

I have the following situation:

- multiple labels named label4_1, label4_2.....label4_20

- one combobox

I want to populate this combobox with the text from all those labels. How can I do this?

Thank you,

Catalina

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Anchov 1,986 on at

Like
a
(0)

Report
Copy link

Link copied!
UPDATED FORMULA:

You can achieve this by using the "Items" property of the ComboBox and the "Concatenate" and Split function to concatenate the text from all the labels.
Here's an example formula that you can use for the "Items" property of the ComboBox:

Split(Concatenate(Label4_1.Text, ",", Label4_2.Text, ",", Label4_3.Text, ",", Label4_4.Text, ",", Label4_5.Text, ",", Label4_6.Text, ",", Label4_7.Text, ",", Label4_8.Text, ",", Label4_9.Text, ",", Label4_10.Text, ",", Label4_11.Text, ",", Label4_12.Text, ",", Label4_13.Text, ",", Label4_14.Text, ",", Label4_15.Text, ",", Label4_16.Text, ",", Label4_17.Text, ",", Label4_18.Text, ",", Label4_19.Text, ",", Label4_20.Text), ",")

This formula concatenates the text from all the labels using commas as separators, then splits resulting string by the comma as the items for the ComboBox.
Note that if you add or remove labels, you'll need to adjust the formula accordingly.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt
RusselThomas 4,014 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @catalinaA ,
I haven't tested, but in theory this would work in the Combo Items: property;

Table( {Result: Label1.Text}, {Result: Label2.Text}, {Result: Label3.Text}, {Result: Label4.Text} )

The display field on the combo would then be "Result"...
Hope this helps,
RT

[update: tested quickly and it works fine on my side]
catalinaA 11 on at

Like
a
(0)

Report
Copy link

Link copied!

I search for a method to include something like this : label4_n, where n between 1 and 20.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@catalinaA

Your request is unusual. Typically, a list or table is used or the items are hard coded with known values.
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Heya @Anchov

Concat applies an expression over a table to create a single string, so it wouldn't work for Items as that requires a table of values 🙂