Power Platform Community Forum Thread Details

Hi,

I have created a gallery logged items in the app. Backend system is SharePoint.

I have created various search functions:

Search by: ID & Title & Risk/Issue & Risk Category & Raised by & Risk owner and Mitigation owner:

I have created the code below does work for all the search category however the ID column does not do any kind of search.

Gallery label is galriskissue

SortByColumns(

Search(

Filter(

RiskIssueTrackerV2,

Len(txtNameFilter.Text) = 0 || StartsWith('Your name'.DisplayName,txtNameFilter.Text),

Len(txtMitigationOwner.Text) = 0 || StartsWith('Mitigation Owner'.DisplayName,txtMitigationOwner.Text),

Len(txtRiskOwner.Text) = 0 || StartsWith('Risk or Issue Owner'.DisplayName,txtRiskOwner.Text),

Len(RiskorIssue.Selected.Value) = 0 || 'Risk or Issue'.Value = RiskorIssue.Selected.Value,

Len(DataRiskCat.Selected.Value) = 0 || 'Risk or Issue Category'.Value = DataRiskCat.Selected.Value),

TxtTitle.Text,

"Title"),

"ID",

If(varSortDirection = SortOrder.Ascending,SortOrder.Descending,SortOrder.Ascending))

I also get a delegable warning however i only have about 50 items logged (which is less than 2000)

Please help?

Categories:

PowerApps Gallery search function not working