Unanswered

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)

Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
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 153,034 Most Valuable Professional on at

Like (0)

Report
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 (0)

Report

Hi Nandit

Your answer didn't work.

Was this reply helpful? Yes No