Announcements
Is it possible to count the number of selected items in a list box?
I have tried this but it throws an error:
CountIf(IsEmpty(MultiSelectList.SelectedItems)),"0",MultiSelectList.SelectedItems)
Hi
CountIf(Table, LogicalFormula)
- I look at you case, the MultiSelectList,SelectedItems is Not a Condition, so, nothing would be filtered and counter.
Hope I am not out of your question!.
NB:
BTW, I had replied to another thread on your Q about LookUp couple of days ago. Please check if it helps.
Thank you for your response.
Wouldn't the IsEmpty be a condition?
Is this closer? (still gives an error message):
CountIf(ListBoxControlName, ListBoxControlName.SelectedItems<>0)
You can use the CountRows function to get that number:
CountRows(ListBox1.SelectedItems)
I have just fallen in love with you! (Although I feel kinda dumb to not have thought of them as rows-LOL).
Last question: Do you know how to clear the selection in the list box?
THANK SO VERY MUCH!!
CountRows is right.
I was looking at your original formula and thought you know CountRows, which is straightforward.
For CountIf(Table, Condition) .. condition must be set.
Anyway, things are solved. Enjoy!
Select the ListBox, and set Default as context variable, say
Default = lb
Meantime, set
OnHidden = UpdateContext{lb: " "}); UpdateCobtext({lb: ""}) (or set on any button, etc.)
Once you have selected the value in ListBox, and when you navigate away, it will be set to no selection and when you return to the same screen, you will no more selection.
The above UpdateContext can be used with any behaviour formula.
Hope this helps.
I tried that but it's not clearing the selection. Does it matter that it's a multi-select list box?
@audrieg wrote:I tried that but it's not clearing the selection. Does it matter that it's a multi-select list box?
It doesn't matter.
UpdateContext({xx: " "}); UpdateContext({xx: ""})
take note of : 1st one: " " (with space in between), 2nd one: "" (no space in between)
FYI: This is used very commonly in PowerApps.
Hope you understand my poor explanation.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 345 Super User 2026 Season 2
Mohsin Ali 225
M Bilal Khan 192
