Power Platform Community Forum Thread Details

My canvas app is connected to a SharePoint list that contains more than 2000 items. The search filters on my page work without delegation issue, however it doesn't behave intuitively to users. When they land on the page and change a filter, it doesn't list any items in the gallery until they enter a value/delete a value in the first search field. I struggled with this search function because of delegation issues, I was happy to get it finally working but it's an irritant to users. Any advice would be greatly appreciated.

Here's the page when you first land on it. If you add a filter to the Area or Lead combo box, the gallery items don't display. You need to enter a value in the Search box, then delete it for the gallery to display any items matching the criteria.

Applied a filter, no gallery item displays.

I typed a 1, then deleted it in the Search text box, then 256 items displayed matching the filter.

Here's the items property formula for this gallery another community member helped me with.

The search text box is called inpSearchNameID, it looks up a text value in SharePoint list.

The status combo box is called cmb_Status_1, it looks up a text value in SharePoint list.

The Lead combo box is called cmbLeadAssigned_1, looks up a person column in SharePoint list, permits multiple people.

The Area combo box is called cmbServiceArea_1, looks up a choice column in SharePoint list, permits multiple choices.

Items formula:

SortByColumns(
With(
{
_data: Filter(
WorkRequest,
AppLoad = true,
(StartsWith(
RequestShortName,
inpSearchNameID.Text
) || SearchableID = inpSearchNameID.Text),
Len(cmbStatus_1.Selected.Value) = 0 || StartsWith(
Open_Closed_Text,
cmbStatus_1.Selected.Value
)
)
},
Filter(
_data,
Len(cmbLeadAssigned_1.Selected.Value) = 0 || cmbLeadAssigned_1.Selected.Value exactin Concat(
LeadAssigned,
ThisRecord.Email & ","
),
Len(cmbServiceArea_1.Selected.Value) = 0 || cmbServiceArea_1.Selected.Value exactin Concat(
ServiceAreas,
ThisRecord.Value & ","
)
)
),
"Modified",
SortOrder.Descending
)