filter and count

(0) Share

Report

Posted on by CU21100814-0

Hi. I have a SP List that tracks what projects a provider has responded to. The provider column is just text and the response is a Choice column of Received or Decline. I want the user to be able to select the provider from a dropdown and then number of responses of decline/receives to show.

I can't get the code to work.

CountIf(Filter(POAP,'POAP provider' = drp_providerA.Selected.'POAP provider')And (POAP,'POAP response'.Value = "Declined"))

Any help would be great, thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi CU21100814-0,

You would need a CountRows function for this:

CountRows(Filter(POAP,'POAP provider' = drp_providerA.Selected.'POAP providerc && 'POAP response'.Value = "Declined"))

For the Received records count, just replace the text "Declined" with "Received".

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
WarrenBelz 155,987 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Firstly, Nandit is correct, so please mark that solution - just for your future knowledge, CountIf will also work (although neither are Delegable) - your syntax was incorrect.

CountIf( POAP, 'POAP provider' = drp_providerA.Selected.'POAP provider' And 'POAP response'.Value = "Declined )

If you want to make this Delegable (count up to your Data Row Limit)
With( { _Data: Filter( POAP, 'POAP provider' = drp_providerA.Selected.'POAP provider' && 'POAP response'.Value = "Declined" ) }, CountRows(_Data) )

Was this reply helpful? Yes No
CU21100814-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Nandit

Your answer didn't work.

Was this reply helpful? Yes No