Unanswered

Collect Combo box selections in columns not rows

(0) Share

Report

Posted on by kgiles123

224

I have a combo box that I've limited to a max selection of three items. Instead of stacking the items in rows in a table I would like the result to populate three columns on a single row with just the Title items that were selected in the combo box.

Here is my current formula:

If(CountRows(Self.SelectedItems)>3,Reset(Self);Notify("Only Three Items Allowed"));
ClearCollect(colTreatment, TreatmentCombo.SelectedItems)

Here is how my collection currently appears:

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @kgiles123 ,

If you create another collection, do you get the Title column only?

Append this code after your colTreatment code

ClearCollect(colTitle, ShowColumns(colTreatment, "Title"));

Hope this helps

Was this reply helpful? Yes No
kgiles123 224 on at

Like (0)

Report
Copy link

Link copied!

thank you for your help! Title is now it's own column. I was hoping that I could have three columns and a single row containing all the selections. Is that possible?

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @kgiles123 ,

Yes, it is possible

For example, use a Label control and insert following formula in the Text/Default

Concat(ColTitle, Title, ", ")

You will get merged data separated with ", "

Hope this helps

Was this reply helpful? Yes No