Answered

sort & filter issue

(0) Share

Report

Posted on by michlwell

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Verified answer

michlwell 18 on at

Like (1)

Report
Copy link

Link copied!

Thank you, I think that has worked.

Was this reply helpful? Yes No