Unanswered

Creating a collection with the last 3 months of data from SharePoint

(0) Share

Report

Posted on by zlunger

Hi all,

I am building a Power App that will pull data from a SharePoint list that has a date in each of the rows. There will likely be thousands of rows in the list eventually, so I am creating a collection for the gallery inside the app.

When creating the collection, is it possible to limit the collection to the last ~3 months of dates in the SharePoint list? If so, how would I do that?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi @zlunger ,

You can do this by filtering:

Filter([YourDataSource],[YourDateColumn] > DateAdd(Now(),-3,Months))

Was this reply helpful? Yes No
zlunger 11 on at

Like (1)

Report

@BCBuizer
Thank you for the solution!

Was this reply helpful? Yes No
Dazza21 16 on at

Like (0)

Report
It appears that the updated syntax for this is below. "Months" is now expected to be "TimeUnit.Months".

Filter( [YourDataSource], [YourDateColumn] > DateAdd( Now(), -3, TimeUnit.Months ) )

Was this reply helpful? Yes No