Using a listbox, counting the number of selected rows and attribute count to a value

(0) Share

Report

Posted on by Gana_Dube

Hi,

How can I count the number of select rows in a list box and attribute all those select items to one value i.e. 3.

The current row selection will tally all the number of select rows, meaning if I select 2 rows, the result is 2.

What I want to do is say whether you select one item or 5 items, the result is 3. It's a scoring system.

Selecting from the approved list, gets you 3, selecting from the non functional list, gives you a 1, selecting from

both lists give you a 2.

The code for counting the selected rows is as below.

CountRows(listbox1.SelectedItems)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Gana_Dube

If(CountRows(listbox1.SelectedItems)>0,3,0) or

If(CountRows(listbox1.SelectedItems)>0,3,Blank())

Was this reply helpful? Yes No
Gana_Dube 99 on at

Like
a
(0)

Report
Copy link

Link copied!
@Drrickryp the result I'm getting from your code is a Boolean value, I think because of the Or condition. The result I am trying to get is something as below.

If( CountRows(listbox1.SelectedItems) > 0 , 3, If(And(CountRows(listbox1.SelectedItems) > 0, CountRows(listbox2.SelectedItems) > 0), 2, CountRows(listbox2.SelectedItems) > 0 , 1, 0 ))
The first and the last condition work, the middle condition does not work.

Below does not work.
If(And(CountRows(listbox1.SelectedItems) > 0, CountRows(listbox2.SelectedItems) > 0), 2,
Meaning if any items of list1 and list2 are selected, the result should be 2.

Thank you.

Was this reply helpful? Yes No
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hey @Gana_Dube

Have you tried the condition in this order:

If( And( CountRows(listbox1.SelectedItems) > 0, CountRows(listbox2.SelectedItems) > 0) ,2, CountRows(listbox1.SelectedItems) > 0 ,3, CountRows(listbox2.SelectedItems) > 0 ,1,0)

Was this reply helpful? Yes No
Gana_Dube 99 on at

Like
a
(1)

Report
Copy link

Link copied!

@AJ_Z this worked as requested🙂, I'm chuffed. Thank you very much.

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Gana_Dube,

I am delighted I could help and thanks Drrickryp for your work getting close to the solution :).

Take care and good luck with your Power App!

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Gana_Dube

If I am understanding, you actually have 4 possible conditions as following

With({cond1:CountRows(listbox1.SelectedItems) > 0 && CountRows(listbox2.SelectedItems) > 0, // both have selections cond2:CountRows(listbox1.SelectedItems) > 0 && CountRows(listbox2.SelectedItems) = 0, // only lb1 has selections cond3:CountRows(listbox1.SelectedItems) = 0 && CountRows(listbox2.SelectedItems) > 0, // only lb2 has selections cond4:CountRows(listbox1.SelectedItems) = 0 && CountRows(listbox2.SelectedItems) = 0 // neither has selections }, If( cond1, 2, cond2, 3, cond3, 1, cond4, 0 ) )

Was this reply helpful? Yes No