Forum Discussion

Iron Contributor

Apr 13, 2022

Filter my Gallery by Current Month

Hi guys, I have a gallery view that contains record from a sharepoint list, in that one there is a field called MBirth, this is a single line text, so How can I filter my list that field? I mean,...

Iron Contributor

Hi ADumith , immediately after you create the variable on start, add a line to create your collection, something like this: ClearCollect(colBirthDayWorkAnniversary,Filter(birthday_and_workanniversary,mbirth=varMonths));

Your gallery object items would then use the newly populated collection (in my example the SharePoint list is named 'birthday_and_workanniversary').

ADumith

Iron Contributor

Apr 15, 2022

jonlake

Thanks for your time,

I renamed the list to avoid errors.

So the code in the OnStart method looks like this:
Set(varMonths, Text(Today(),"mm"));
ClearCollect(colBirthDayWorkAnniversary,Filter(EmployeesDirectory,Mbirth=varMonths))

Then in the gallery DATA property I put what I understand would be the name of the collection, I mean, colBirthDayWorkAnniversary

When I run the apps no record is shown in the gallery. Am I skipping a step?

Thanks again,

jonlake
Iron Contributor
Apr 15, 2022
Hi ADumith, you need to set the gallery items property to the collection (colBirthDayWorkAnniversary).
- ADumith
  Iron Contributor
  Apr 15, 2022
  jonlake
  
  I did it, but doesn't show any record
  
  Thanks for your support.
  - jonlake
    Iron Contributor
    Apr 15, 2022
    Hi ADumith , click the edit icon (the pencil) and add in label fields and map them to the fields in the collection.