I am filtering a Sharepoint list by todays date and getting the total count of the length of that filtered list. I know there are 10 items in that filtered list but the filter value is returning 12. Am I doing something wrong?
Announcements
I am filtering a Sharepoint list by todays date and getting the total count of the length of that filtered list. I know there are 10 items in that filtered list but the filter value is returning 12. Am I doing something wrong?
Hi @sskey89,
The expression you are sharing is calculating the length of the text/string 'Filter_array'. That text/string is 12 characters.
If you want to know the number of items from your filter array results try using an expression with the outputs body of the filter array. Try something like below:
length(body('Filter_Array'))
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1