web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps HOW TO FILTER DATE RAN...

Power Apps

Answered

HOW TO FILTER DATE RANGE IN SHAREPOINT USING POWER APP

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Am trying to spool record from sharepoint using powerapp.

I have record from 2022 to 2023 on the same list.

I want powerapp to only display only records for 2023.

In Sharepoint: I have DATE column in this format 3/17/2023 (MM/DD/YYYY)

CUrrently, below is my code in powerapp, but this spool both 2022 & 2023

CountIf (
Signature,
STATUS.Value = "available"
)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

The filter below will only show records of 2023. I made some adjustments to make the query delegable: CountRows & Filter() instead of CountIf() and less than or equals & greater than to filter the date field. You will still get a delegation warning because CountRows is not delegable, since it cannot count over 2000 records. However, the inner Filter() function is delegable.

CountRows( Filter( Signature, STATUS.Value = "available" && (DateField >= Date(2023,1,1)&& DateField < Date(2024,1,1)) ) )

Adjust the column & list name where necessary.

If this solves your question, would you be so kind as to accept it as a solution.

Thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you @LaurensM

It worked!

Was this reply helpful? Yes No

Join the conversation