web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / sort & filter issue
Power Apps
Answered

sort & filter issue

(0) ShareShare
ReportReport
Posted on by 18

I am having delegation issues, SharePoint List is very large, I don't know how to incorporate a filter so I can show only 2024 data. What am I doing wrong?

 

SortByColumns(Filter(_CallReportDB, Or(If(!IsBlank(ThisItem.'F Sales Code'))FSalesCode = ThisItem.'F Sales Code'), If(!IsBlank(ThisItem.'L Sales Code'),LSalesCode = ThisItem.'L Sales Code')) && Or(Status.Value - "DONE", Status.Value = "COMPLETED")), && "Date" >= Date(2024, 1,1)), "Date", SortOrder.Descending)

 

Categories:
I have the same question (0)
  • Verified answer
    mmbr1606 Profile Picture
    14,615 Super User 2026 Season 1 on at

    hey @michlwell 

     

    Here's a simplified and more delegation-friendly version of your formula focused on filtering by the 2024 date. This assumes your 'Date' column is delegable and formatted correctly in SharePoint (e.g., DateTime type):

     

    SortByColumns(
     Filter(
     _CallReportDB, 
     Year(Date) = 2024,
     (IsBlank(ThisItem.'F Sales Code') || FSalesCode = ThisItem.'Ford Sales Code') && 
     (IsBlank(ThisItem.'L Sales Code') || LSalesCode = ThisItem.'L Sales Code') && 
     (Status.Value = "DONE" || Status.Value = "COMPLETED")
     ), 
     "Date", 
     Descending
    )
    

     

    Let me know if my answer helped solving your issue.

    If it did please accept as solution and give it a thumbs up so we can help others in the community.



    Greetings

  • Verified answer
    michlwell Profile Picture
    18 on at

    Thank you, I think that has worked.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard