Answered

Delegation warning on filtering a text field

(0) Share

Report

Posted on by ReneeB

I have a filter set on the items property of a gallery, the data source is a sharepoint list 'Registration Requests'. The filter is based on the inputs in cbStatus_3 and cbProduct_2, and the columns 'Status' and 'Product Type' are both plain text input field columns.

When I only add the first argument into filter (Status), the filtering works fine. However, when I include the Product Type filtering, I get a delegation warning and the gallery returns no records. The datasource currently only has about 490 records in total but will grow to be quite large. Any ideas???

Sort(
Filter(
'Registration Requests',IsBlank(cbStatus_3.SelectedItems.Value) || IsEmpty(cbStatus_3.SelectedItems) || Status = cbStatus_3.Selected.Value,
'Registration Requests',IsBlank(cbProduct_2.SelectedItems.Value) || IsEmpty(cbProduct_2.SelectedItems) || 'Product Type' = cbProduct_2.Selected.Value
),
Created,SortOrder.Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

ReneeB 18 on at

Like
a
(1)

Report
Copy link

Link copied!

I'm an idiot. Correct formula for users going through something similar:
Sort(
Filter(
'Registration Requests',
IsBlank(cbStatus_3.SelectedItems.Value) || IsEmpty(cbStatus_3.SelectedItems) || Status = cbStatus_3.Selected.Value,
IsBlank(cbProduct_2.SelectedItems.Value) || IsEmpty(cbProduct_2.SelectedItems) || 'Product Type' = cbProduct_2.Selected.Value
),
Created,SortOrder.Descending)

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ReneeB,

You indeed only have to mention your datasource once within a Filter() statement - glad the issue is resolved. 🙂
In order to close the topic and make the solution easier to find - you can accept your reply as a solution.

Was this reply helpful? Yes No