Filter and Count rows by Date

[caslasgee]

Hi,

I have a SharePoint list.

I will like like to populate the year(date) in a Drop-down and display in a label result in a label. I used clear collect to populate the year using the date column from the SharePoint list.

ClearCollect(Dyear,DVisit)

Then i added the following to my Drop-down.

Distinct(Dyear,Year(StartDate))

I added a label but it wouldn't display anything. See formula used below.

CountRows(Filter(DVisit, Dyear = drpdyear.Selected.Value))

Thanks.

[caslasgee]

@WarrenBelz, Yes, This is an integral part of the requested support. Couldn't put all the questions in one thread. 

[TheRobRush]

Since that worked, putting this in your dropdown should give you the dropdown years.

Distinct(AddColumns(DVisit, "yearCheck", Year(StartDate)), yearCheck).Value

In the future if you have more than one issue and @WarrenBelz is already assisting you feel free to bring your additional issues up and he will almost always help you. Warren is a great guy that all of us look up to here haha

[caslasgee]

Thanks for your effort @TheRobRush , Based on my initial question, I want it in a label (count by year) instead of a Gallery such that whenever a year is selected, It gives the count of records and displays it in a label. And by the way, thanks for the tips regarding posting all your questions in just one thread.

For the record, @WarrenBelz In my honest opinion, Isn't just a great guy, but the one of the best i have ever seen and someone i also look up to.

Thanks.

[TheRobRush]

Initially you also wanted a dropdown that included years, and then the label would count them. Get the dropdown working and let me know it did, then we will tackle the label.

[caslasgee]

@TheRobRush, The drop-down works fine now. Sorry i skipped that part in my previous post. Thanks

[TheRobRush · Accepted solution]

Great, then place this in a label

CountRows(
       Filter(
             AddColumns(DVisit, "yearCheck", Year(StartDate)),
             yearCheck = drpdyear.Selected.Value
             )
         )

[caslasgee]

Thank you for your support all the way.