Listbox & Combo box

[Ralino]

Hi dears

Want to use the multiple value I have selected either in Listbox or Combo box in another calculation cell.

How I can call these selection separately please?

Thanks

[yashag2255]

Hey @Ralino 

How do you want to use the selected values? Can you share more logical details of this scenario?

You can access the Combobox selected items using Combobox1.SelectedItems and ListBox selections using ListBox1.SelectedItems.

If you can share schema level details, we might be able to help you better.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Ralino]

Thanks Dear

Assuming I have List box or Combo box of : A, B, C, D. in this order.

I selected A,B.

in Another table I have a list of letter associated to sale amount.

I will be having 2 labels : 1st label should bring sales amount of first selection " A" through lookup and 2nd label should bring sales amount of 2nd selection " A"

Hope it's clear to give feedback.

Thanks

[v-monli-msft · Accepted solution]

Hi @Ralino ,

In you last sentence, did you mean "2nd label should bring sales amount of 2nd selection "B""? If so, then please follow below steps to achieve this.

In my example, I assume that it is a combo box control.

Set below formulas in the 2 Label control:

Label1.Text=Sum(Filter(DataSourceName,Column1=First(ComboBox1.SelectedItems).Result),Number)
Label1.Text=Sum(Filter(DataSourceName,Column1=Last(FirstN(ComboBox1.SelectedItems,2)).Result),Number)
...

Column1 is the field that you want to filter the data source with the value from combo box. Number is the column that you want to sum the number. 

And if you have more than 2 selections that you want to filter and sum, you can have as many labels as you want.

Regards,

Mona