Power Platform Community Forum Thread Details

My gallery has stopped displaying items and I can't figure out why. There's no delegation warning or visible error I can find. I've not changed the properties of this gallery, it was working fine before. Any help is appreciated.

Canvas Power App has connections to multiple SharePoint lists. The SharePoint list in question is 'ActivityLog' which has 5000+ items. The ActivityLog recently surpassed 5000 items, I'm not sure if that's the cause of this issue.

ActivityLog has columns:

CrossReference [single line of text]
EventDate [Date/time]
Created [Date/time]
Title [single line of text]
Description [single line of text]
Type [single line of text]

Properties for this gallery are:

DisplayMode: DisplayMode.View
Items:

SortByColumns(

Filter(

ActivityLog,

StartsWith(

CrossReference,

DataCardValue134.Text

)

),

"EventDate",

If(

ascendingOrder = true,

SortOrder.Ascending,

SortOrder.Descending

)

)

The CrossReference is the text field in the SharePoint list 'ActivityLog'. The DataCardValue134.Text is the text value of a control on the page, this filters the items displayed on the page from the ActivityLog. There's a sort icon on the page that will switch the ascendingOrder variable from true to false or vice versa, this enables the user to sort the items in descending or ascending date order.

If I click on the Filter function in the formula bar, the preview illustrates there are items matching the filter condition, refer screenshot 1.

Screenshot 1

What baffles me is if I change the SortByColumns in the gallery items formula from 'EventDate' to 'Created', the gallery works, items are displayed, albeit in the Created date order, rather than the EventDate order. Any idea on what's causing this issue for EventDate/SortByColumns? Thanks.

Categories:

Building Power Apps