Challenge:
I have 4 Dropdowns. All have items populating from a collection. Additionally, I have added a default "-" to each dropdown.
I would like to count 'how many' of the dropboxs are populated with a selection excluding the "-" (desired result shown image)
Accepted Solutions
Hi @tianaranjo,
Since all the Count functions need to count values from Table, to do this, you will need to add a button control and create a collection before counting. Set the OnSelect property of the button to:
ClearCollect(C,{Test:Dropdown1.Selected.Value},{Test:Dropdown2.Selected.Value},{Test:Dropdown3.Selected.Value},{Test:Dropdown4.Selected.Value})
Use below formula on the Text property of the label control to show the count number:
CountIf(C,Test<>"-")
Regards,
Mona
Hi @tianaranjo,
Since all the Count functions need to count values from Table, to do this, you will need to add a button control and create a collection before counting. Set the OnSelect property of the button to:
ClearCollect(C,{Test:Dropdown1.Selected.Value},{Test:Dropdown2.Selected.Value},{Test:Dropdown3.Selected.Value},{Test:Dropdown4.Selected.Value})
Use below formula on the Text property of the label control to show the count number:
CountIf(C,Test<>"-")
Regards,
Mona
Helpful resources
Join us for Microsoft Power Platform Conference
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Register for a Free Workshop
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
New Release Planning Portal (Preview)
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.
