Answered

Countrows of a gallery that are dropdown boxes

(0) Share

Report

Posted on by forest2002

Hi,

Some help would be really appreciated, going out of my mind and feel it should be painfully easy. I have a Gallery with 6 columns and each of them is a dropdown box with the same 3 choices which is a choices field in Sharepoint "Work", "Home", "A/L". I want to be able to count the rows and given me a total of how many times "Office" appears on a row.

CountRows( Filter( Gallery4.AllItems, DropdownKaren.Value = "Office" ))

I've been trying all sorts of variations around this but getting nowhere

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Can you share some pics of your app please

Was this reply helpful? Yes No
forest2002 64 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @forest2002 ,

I did a demo for you.

I have 3 same dropdown controls in my gallery.

Their Items property:

["Office","A","B"]

Insert a lable control and set its Text property to:

CountRows(Split(Dropdown1.Selected.Value&Dropdown1_1.Selected.Value&Dropdown1_2.Selected.Value,"Office"))-1

Best Regards,

Wearsky

Was this reply helpful? Yes No
forest2002 64 on at

Like (0)

Report
Copy link

Link copied!

Absolute legend thank you so much!!!!

Was this reply helpful? Yes No