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

Apr 14, 2022

Hi ADumith , I recommend setting a variable on start for the current month, formatted to match the format in your source list, then after you've set that variable create your collection filtered by that variable. You would than set the collection as the source for the gallery.

ADumith
Iron Contributor
Apr 14, 2022
jonlake
Great idea,

I did this:

In the items I added this:

In my list the field is set like a single line text, so mi record has 04 instead of 4.

Where is the error? 😞

Thanks in advance,
- jonlake
  Iron Contributor
  Apr 14, 2022
  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,

Share

Resources