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:

Using Apps Using Formulas

General Questions

All responses (3)

Answers (0)

CU21100814-0 2 on at

Like (0)

Report

filter and count

Hi Nandit

Your answer didn't work.
WarrenBelz 146,651 Most Valuable Professional on at

Like (0)

Report
filter and count

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) )
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report
filter and count

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!