Answered

Filter by Date not working

(1) Share

Report

Posted on by Sirbatchu

Hi Hoping I could get some help

My filter on my sharepoint list is returning blank table.

In Summary I am trying to have it always return the current year as the dynamic value, but then all items within the month of January

The Code:

With(
    {
        StartDateJan: Date(
            Year(Today()),
            Month(1),
            Day(1)
        ),
        EndDateJan: Date(
            Year(Today()),
            Month(1),
            Day(31)
        )
    },
    ClearCollect(
        PackagesJanNewChartvar,
        Filter(
            'Alldeliveredvar',
            Created >= StartDateJan,
            Created <= EndDateJan
        )
    )
)



The SP List
 

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Daniel Bocklandt 5,117 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hey,

could you try to change it like this:

With( { StartDateJan: Date( Year(Today()), 1, 1 ), EndDateJan: Date( Year(Today()), 1, 31 ) },....

Either this or you need to enter a complete Date into Month() and Day().

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
Sirbatchu 71 on at

Like (0)

Report
Copy link

Link copied!

Hi DBO DV, thanks for the post.

Unfortunately, this did not make any difference, still a blank table.

Was this reply helpful? Yes No
timl 36,634 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

I would have thought that @DBO_DV's suggestion would work.

Could you confirm what 'Alldeliveredvar' is? Judging by the name, is a variable rather than the actual SharePoint list?

Was this reply helpful? Yes No
Daniel Bocklandt 5,117 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey @Sirbatchu,

I've just got another idea. Maybe it is a Formating problem.

Just add the Datasoruce in a gallery and put 'Created' in a Textlabel.

Sometimes it doesn't work as expected when you compare DD/MM/YYYY with MM/DD/YYYY. Could you check if the date frome SharePoint and The variable are the same?

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
Verified answer

Sirbatchu 71 on at

Like (0)

Report
Copy link

Link copied!

Hi All

Firstly, massive apology, I believe you are all correct, the formula I believe does indeed work, the issue is actually the old delegation issue.

I have 2000+ records, and powerapps was set to only grab 500, I believe to combat this, as I am only wanting to fetch the current years records, I could do something that includes "Last" or, look at scrubbing the sharepoint list a bit to reduce the amount of records present.

Regards

Matt

Was this reply helpful? Yes No