Answered

Concat Combox selected items

(0) Share

Report

Posted on by SteveDK

Hi all.

I hope you could help me out with getting the results from a ComboBox1?

I have a table called 'BLB Numbers' with 2 columns, 'Title' (where the customer numbers are stored) and 'Bill-to Customer Name'.
I'm using a ComboBox1 to select multiple customer numbers in the Title column and what I try to do is to get the Bill-to Customer Name's by the selected customer numbers from the ComboBox1.

Thank you,
Steve

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @SteveDK ,

Assuming Title is also the output (.Selected.Title) of the Combo Box - on the OnChange

Clear(colNames); ForAll( Self.SelectedItems As aLU, Collect( colNames, { CustName: Lookup( 'BLB Numbers', Title = aLU.Title, ).CustomerNameField } ) )

then the Default of your bottom box

Concat( colNames, CustName & "," )

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.

Was this reply helpful? Yes No
SteveDK 17 on at

Like (0)

Report

Thank you @WarrenBelz

It really did the job and exactly what I was looking for. 👌

Was this reply helpful? Yes No