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.
Solved! Go to Solution.
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.
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.
Could you please provide a screenshot of the form you are referring to and indicate the type of control that is inside the card.
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!
Nevermind, I got it! Thank you gentlemen!
User | Count |
---|---|
252 | |
102 | |
94 | |
50 | |
37 |