Power Apps Filter Gallery By Last Month [With Various Examples]

This Power Apps tutorial will help you to learn Power Apps Filter Gallery By Last Month with various scenarios.

Additionally, I will show you how to filter Power Apps gallery by Last N months and how to filter Power Apps gallery by Current month with simple code.

Also, we will learn how to work with Power Apps Filter Gallery by Month Using Dropdown Control.

Check out: Power Apps Gallery Control Examples Download [20 Various Real Scenarios]

Set up a SharePoint List

I have used a SharePoint list Job Seekers Registration List for all the above examples. This list has these many columns (with different data types):

ColumnsData types
First NameSingle line of text (This is a Title column, I just renamed it to First Name)
SurnameSingle line of text
Registration IDNumber
Apply DateDate and time

Additionally, as seen in the screenshot below, this list contains some records.

How to filter Power Apps Gallery by Last month

Power Apps Filter Gallery By Last Month

Here, we will see how to filter Power Apps Gallery By Last month.

  • The gallery in the image below shows all of the records from the previous month. Since my current date is “8/18/2023,” it displays all the records for July.
Power Apps Filter Gallery By Last Month
  • To achieve this, apply the code below on the Gallery’s Items property:
Items = With(
    {
        StartDate: Date(
            Year(Today()),
            Month(Today()) - 1,
            1
        ),
        EndDate: Date(
            Year(Today()),
            Month(Today()),
            1
        ) - 1
    },
    Filter(
        'Job Seekers Registration List',
        'Apply Date' >= StartDate,
        'Apply Date' <= EndDate
    )
)

Where,

  1. StartDate, EndDate = Scope variable names
  2. Job Seekers Registration List‘ = SharePoint List Name
  3. Apply Date‘ = SharePoint Date Column Name
Power Apps Gallery Filter By Last Month

This is all about Power Apps Filter Gallery By Last Month.

See also  Power Apps Today Date Without Time | Power Apps Now()

Power Apps Filter Gallery By Last N Month

Next, we will see how to filter Power Apps Gallery By Last N Month. (till current date)

  • In this example, I would like to filter the Power Apps gallery by the last two months. The gallery will filter and show the data from the most recent two months, i.e., June and July, up until today’s date, since today’s date is “8/18/2023“.

Refer to the image below.

Power Apps Filter Gallery By Last N Month
  • To do so, select the Gallery control and set its Items property to the formula below:
Items = With(
    {
        StartDate: Date(
            Year(Today()),
            Month(Today()) - 2,                                     // specify the number
            Day(Today())
        ) + 1,
        EndDate: Date(
            Year(Today()),
            Month(Today()),
            Day(Today())
        )
    },
    Filter(
        'Job Seekers Registration List',
        'Apply Date' >= StartDate,
        'Apply Date' <= EndDate
    )
)

Where,

  1. StartDate, EndDate = Scope variable names
  2. 2 = Specify the last month number that you want to filter
  3. Job Seekers Registration List‘ = SharePoint List Name
  4. Apply Date‘ = SharePoint Date Column Name
Power Apps Gallery Filter By Last N Month

This is how to work with Power Apps Filter Gallery By Last N Month (till today’s date).

Power Apps Filter Gallery By Current Month

Additionally, suppose you want to filter the Power Apps gallery by current month. Then, in this case, follow the below approaches.

  • As my current month is August (8), the below gallery filtered and displayed all the records based on the current month.
Power Apps Filter Gallery By Current Month
  • To work with this, apply the code below on the gallery’s Items property as:
Items = Filter(
    'Job Seekers Registration List',
    Month('Apply Date') = Month(Now())
)

Where,

  1. Job Seekers Registration List‘ = SharePoint List Name
  2. Apply Date‘ = SharePoint Date Column
Power Apps Gallery Filter by Current Month

This is all about Power Apps Filter Gallery By Current Month.

See also  How to Sort Gallery by Person Column in Power Apps?

Power Apps Filter Gallery by Month Using Dropdown Control

Do you want to filter the Power Apps gallery by month using a Dropdown control? No worries! It’s so simple.

  • Here, I want to create a Power Apps Dropdown with the months (whether they are represented by the digits 1, 2, and 3, which stand for January, February, March, and so on) and then use that to filter my gallery.
  • For example, the gallery filtered and presented all the July records when I choose the month of JULY from the drop-down control, as seen below.
Power Apps Filter Gallery by Month Using Dropdown Control
  • To work with this, Create a Power Apps Collection on the OnStart property of the app as below:
OnStart = ClearCollect(
    collMonths,
    {
        ID: 1,
        Name: "JANUARY"
    }
);
Collect(
    collMonths,
    {
        ID: 2,
        Name: "FEBRUARY"
    }
);
Collect(
    collMonths,
    {
        ID: 3,
        Name: "MARCH"
    }
);
Collect(
    collMonths,
    {
        ID: 4,
        Name: "APRIL"
    }
);
Collect(
    collMonths,
    {
        ID: 5,
        Name: "MAY"
    }
);
Collect(
    collMonths,
    {
        ID: 6,
        Name: "JUNE"
    }
);
Collect(
    collMonths,
    {
        ID: 7,
        Name: "JULY"
    }
);
Collect(
    collMonths,
    {
        ID: 8,
        Name: "AUGUST"
    }
);
Collect(
    collMonths,
    {
        ID: 9,
        Name: "SEPTEMBER"
    }
);
Collect(
    collMonths,
    {
        ID: 10,
        Name: "OCTOBER"
    }
);
Collect(
    collMonths,
    {
        ID: 11,
        Name: "NOVEMBER"
    }
);
Collect(
    collMonths,
    {
        ID: 12,
        Name: "DECEMBER"
    }
);

Where,

  1. collMonths = Provide a collection name
  2. ID, Name = Specify the Collection headers
  3. 1, “JANUARY“, and so on = Provide values to the ID and Name
Power Apps Filter Gallery by Month Using Dropdown
  • Insert a Dropdown control and set its Items property as:
Items = collMonths

collMonths = Collection name that you have created on the App’s OnStart property

Power Apps Gallery Filter by Month Using Dropdown Control
  • Next, select the gallery control and set its Items property as:
Items = Filter(
    'Job Seekers Registration List',
    Month('Apply Date') = ddMonths.Selected.ID
)

Where,

ddMonths = Dropdown control name

Power Apps Gallery Filter by Month Using Dropdown
  • Now, click on the App’s ellipses () under the Tree view -> Click on the Run OnStart option.
Filter Power Apps Gallery by Month Using Dropdown
  • Save, Publish, and Preview the app. When the user will select any month from the dropdown menu, according to that month’s selection, the gallery will filter and show the result.
See also  Dataverse Version History

This is how to work with Power Apps Filter Gallery by Month Using Dropdown Control.

Furthermore, you may like some more Power Apps tutorials:

In this Power Apps tutorial, we discussed all about Power Apps Filter Gallery By Last Month with various scenarios.

Additionally, we saw how to filter Power Apps gallery by Last N months and how to filter Power Apps gallery by Current month with simple code.

Also, we learned how to work with Power Apps Filter Gallery by Month Using Dropdown Control.

>