Answered

How to count records within the current year?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to see how many records each person has entered for the current year from a sharepoint list. Here is what I have below:

"Current Year Count for " & User().FullName & ": " & CountRows( Filter(
Collection1,
Created >= Date(Year(Today()), Year(Today()), 1),
Created < Date(Year(Today()), 1 + Year(Today()), 1), IsMatch( 'Created By'.Email, User().Email)))

Please Help! Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

jhall 636 on at

Like (0)

Report
Copy link

Link copied!

Weeeelll...copying/pasting your calculation:
Date(Year(Today()), Year(Today()), 1)
...into a label gives:
3/1/2187
...so maybe start there.

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
You just need to use Year(Created), then it will return the created year.
Try this formula:
"Current Year Count for " & User().FullName & ": " & CountRows( Filter(Collection1,Year(Created)=Year(Today())))

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Wow, this method is so much more effective. Thank you!

Here's what I came up with!

CountRows( Filter(
Collection1,
Created >= Date(Year(Today()), 1, 1),
Created < Date(Year(Today()), 12, 31), IsMatch( 'Created By'.Email, User().Email)))

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@v-yutliu-msft wrote:
Hi @Anonymous ,
You just need to use Year(Created), then it will return the created year.
Try this formula:
"Current Year Count for " & User().FullName & ": " & CountRows( Filter(Collection1,Year(Created)=Year(Today())))

Best regards,
Community Support Team _ Phoebe Liu
Will this also work on a table. I have grouped my data by the creator and then I want to count how many each user can submitted how many entries for the year. I have made a gallery to put these two columns in.

GroupBy(AddColumns(Collection1, "UserDisplayName", 'Created By'.DisplayName), "UserDisplayName", "GroupByUsersDisplayName")

CountRows( Filter(GroupByUsersDisplayName,Year(Created)=Year(Today())))

It seems like it is working, but I just want to make sure.

Was this reply helpful? Yes No
jhall 636 on at

Like (1)

Report
Copy link

Link copied!

Yes, this will work on a Table (i.e. Collection). PowerApps essentially treats (for the most part) any complex data type that groups fields together into a Collection and any of the functions you see that do operations on data sources are treating those sources as Collections as well.

Was this reply helpful? Yes No