Show items that has been modified in the last 7 days

(2) Share

Report

Posted on by Charlie Martharper

943 Season of Giving Solutions 2025

Hi!

I have a list that will be modified some of the items but not much. The thing is to have a gallery + form that shows only the items that has been modified in the last 7 days aprox.

Also, should be nice to add a pop up with the number of the items/rows in the main screen. Like a text label but circular and with the number in it.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Vish WR 3,748 on at

Like
a
(3)

Report
Copy link

Link copied!

@Charlie Martharper

You can filter the gallery to show only recently modified items using the Modified column:
Filter(YourList, Modified >= DateAdd(Today(), -7, Days))

For the count badge, place a small circular label on the screen and set its Text property to:
CountRows(Filter(YourList, Modified >= DateAdd(Today(), -7, Days)))

That will display the number of items modified in the last 7 days and update automatically as records change.

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@Charlie Martharper,

Gallery (Items) Property

With(

    {

        _recentItems: Filter(

            YourListName,

            Modified >= DateAdd(Today(), -7, Days)

        )

    },

    _recentItems

)

Count Rows :

With(

    {

        _recentItems: Filter(

            YourListName,

            Modified >= DateAdd(Today(), -7, Days)

        )

    },

    CountRows(_recentItems)

)

More Information : CountRows datatable based on column value

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Charlie Martharper,

Vish and Ragavendar are correct. One thing to add: the Modified >= DateAdd(Today(), -7, Days) filter is delegable to SharePoint, so it works correctly even for large lists over 500 rows.

For the circular badge, set the label Width and Height to the same value (e.g. 40), set BorderRadius to 50, add a background colour and centre the text. That gives you the circular notification look.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Charlie Martharper,

Filter the gallery items property:

Filter(
YourSharePointList,
Modified >= Today() - 7
)

Bind the Form to the selected item in the gallery

GalleryName.Selected

For the circular pop-up showing the count of these items on the main screen:

Add a Label control.

Set its Text property to: CountRows(Filter(YourSharePointList, Modified >= Today() - 7))

Style the label to be circular by setting:

Width and Height to the same value (e.g., 40)

BorderRadius to half the width (e.g., 20)

TextAlign and VerticalAlign to Center

Fill and Color for visual emphasis

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
Kushal_M 296 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @Charlie Martharper,

Use the gallery’s Items property to filter by the SharePoint Modified column for the last 7 days, e.g.:
Filter(YourListName, Modified >= DateAdd(Today(), -7, Days))

This pattern is commonly used for recent-item galleries, and Modified is the built-in last-updated timestamp in SharePoint.

For the count badge / popup, add a label (or circle + label) and set Text to:
CountRows(Filter(YourListName, Modified >= DateAdd(Today(), -7, Days)))

or, if you want the count of what the gallery is currently showing:
Gallery1.AllItemsCount

Both approaches are standard for showing record counts in Power Apps.

If the list is large, just note that CountRows/Filter can hit delegation limits, so for very large SharePoint lists you may need a delegable workaround or collection strategy.

Was this reply helpful? Yes No
Charlie Martharper 943 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi guys thank you so much for the answers!!

The way it gets correctly the filter is with TimeUnit.Days, not just "Days":

CountRows(Filter('ListName', Modified >= DateAdd(Today(), -7, TimeUnit.Days)))

Thank you for taking time to answer!!

Was this reply helpful? Yes No