cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ralino
Frequent Visitor

Listbox & Combo box

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
yashag2255
Dual Super User II
Dual Super User II

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!

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

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

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,484)