Answered

Prevent string loss when list box refresh

(0) Share

Report

Posted on by NeohLooi

I have a list box which contain a list of item which depend on the dropdown option which user selected. For example, user select chair, my list box will contain item like wooden chair etc, user able select the item in list box and it will appear it at the label.

My label text formula:
Left(Concat(ListBox2_1.SelectedItems,TestParameterName& ", "),Len( Concat( ListBox2_1.SelectedItems,TestParameterName& ", " ) ) - 2)

My problem currently is whenever user go select different dropdown option, for example user select table, the label text will reset. Is that anyway that I can keep the text and user able to continue select next item?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NeohLooi ,

According to your description, I think you could try the collect() function on the onchange property of the combo box control.

For example:
Collect(Test, {Testcolumn : Left(Concat(ListBox2_1.SelectedItems,TestParameterName& ", "),Len( Concat( ListBox2_1.SelectedItems,TestParameterName& ", " ) ) - 2) } )

It will save the value selected by the user.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
NeohLooi 73 on at

Like
a
(0)

Report
Copy link

Link copied!

But I can't show the collection in a label, is that any other way to show the string?
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NeohLooi ,

You could try the following code:
First(Test).Testcolumn // Assign the value of the first record to label
Last(Test).Testcolumn // Assign the value of the last record to label
Last(FirstN(Test,*)).Testcolumn // Assign the value of the *th record to label

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.