CountRows Not Working Properly

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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 on at

Like
a
(0)

Report
Copy link

Link copied!
@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 on at

Like
a
(1)

Report
Copy link

Link copied!

Nevermind, I got it! Thank you gentlemen!
darylvogan 274 on at

Like
a
(0)

Report
Copy link

Link copied!

Why does this remove the warning? Is this a workaround or a proper approach?