CountRows Not Working Properly

[Applications]

Hello all!

I'm trying to get a CountRows formula working but it's not giving me any results.

Here is my current formula:

Text="Number of Participants Currently Enrolled: " & 
CountRows(Filter('Walking Tour Signup Tracker', 'Primary Date' = DataCardValue2.Selected))

 So I want to reference my SP list and the datacard selection within the PowerApp form to return how many people are enrolled against a certain date.

What am I doing wrong? I do get an error saying: "The CountRows operation is not supported by this connector." Is that typical? Do I need to use another formula to achieve this? Thanks.

[RandyHayes · Accepted solution]

@Applications 

CountRows is not supported for the SharePoint connector (and many others).

It still works though, and it is really misleading.

However, Please consider changing your Formula to the following:

"Number of Participants Currently Enrolled: " & 
With({_items: Filter('Walking Tour Signup Tracker', 'Primary Date' = DataCardValue2.Selected)},
    CountRows(_items)
)

This should remove the warning.

I hope this is helpful for you.

[Drrickryp]

@Applications 

Could you please provide a screenshot of the form you are referring to and indicate the type of control that is inside the card.    

[Applications]

@Drrickryp @RandyHayes 

Thanks for the responses! Here is the screenshot, with the modified formula:

Label formula Text property:

Text = "Number of Participants Currently Enrolled: " & 
With({_items: Filter('Walking Tour Signup Tracker', 'Primary Date'.Value = DataCardValue2.Selected.Value)}, 
CountRows(_items))

DataCard2 (Primary Date) Item Property:

Choices([@'Walking Tour Signup Tracker'].'Primary Date')

The label isn't showing my text either, which is very odd. It just says "false". I know I changed it to 'Primary Date'.Value and DataCardValue2.Selected.Value, but it was giving an error when I didn't add the .value at the end. 

Please advise, thanks!

[Applications]

Nevermind, I got it! Thank you gentlemen!