Filtered gallery not showing all records

(1) Share

Report

Posted on by AH-22100006-0

119

Hello,

I have a Power Apps app that has a gallery, connected to a large Sharepoint list.

I am filtering the gallery with radio buttons (status).

I was having issues with using "Search" and learned that there being >2000 records was likely causing me some grief, so I changed it, and have pasted it below.
I no longer receive any warnings, but I still am not seeing all records.

I'm not 100% sure, but some of the filters seem to work - but when I select 'All' - I only see records up to Jan 6, and if I select 'Completed' I only see records up to Jan 26. Both should have records up to and including today.

SortByColumns(
Filter(
    Switch(
        radStatusFilter.Selected.Value,
        "All", Tickets,
        "In Progress", Filter(Tickets, Status.Value = "In Progress"),
        "New", Filter(Tickets, Status.Value = "New"),
        "Completed", Filter(Tickets, Status.Value = "Completed"),
        "On Hold", Filter(Tickets, Status.Value = "On Hold"),
        "Cancelled", Filter(Tickets, Status.Value = "Cancelled"),
        Tickets // Fallback
    ),
    StartsWith(Title, txtSearch.Text)),
    "DateReported", SortOrder.Descending)
 
 
 
Any thoughts or suggestions?



Thanks,
Amber
 

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Dear @AH-22100006-0,

It seems the nested Switch() function in the Filter() function is breaking the delegation despite not showing any warnings. Please try the below formula instead which should give the same result, but is fully delegable:

SortByColumns( Filter( Tickets, ( radStatusFilter.Selected.Value = "All" || Status.Value = radStatusFilter.Selected.Value || IsBlank(radStatusFilter.Selected.Value) ) && StartsWith(Title, txtSearch.Text) ), "DateReported", SortOrder.Descending )

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
AH-22100006-0 119 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much! That did the trick :)

Amber

Was this reply helpful? Yes No