Unanswered

Delegation Warning Filtering List Against People/Group or Choice Columns

(0) Share

Report

Posted on by BeccaSarah90

Hi, I'm quite new to PowerApps and would appreciate any help anyone can give, I feel like its a 'me' issue and the solution should be obvious but I'm not seeing/understanding it.

I'm trying to filter a list within a PowerApp so the user can select a name from a dropdown and this filters against a People/Group Column in the list. I've tried the following:

Filter([@'MyList'], 'Assigned Internal Contact'.DisplayName = ComboBox1.Selected.DisplayName))

Which comes up with the Delegation Warning. This is the same when I try the above expression but for a Choice Column (to a different Combo). Even though its only a warning and I only currently have 10 records in my list, when I preview the app they don't actually work either I'm not sure how to correct so the filter works properly.

Ideally I would list to be able to be filtered by either selecting from either Dropdowns OR a search text box and the list to be completely visible before the user selects either drop down or starts typing in the search box but I've not even looked into that side yet I'm just stuck here

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-peijunz-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BeccaSarah90

The Filter function can be delegated in PowerApps.
In general, the Delegation warning issue is not an error, it just means that you could not delegate the Data process from your app to your data source itself. Instead, you could only process data locally. And you could only process 2000 records locally at most.
More details about the Delegation issue in PowerApps, please check the following article:
Understand delegation in a canvas app - Power Apps | Microsoft Learn

To avoid the delegation, maybe you could try the following ways:
OnStart/OnVisible event of the screen, use collect functions to fetch records as a variable with the following syntax:
Collect(YourCollectionNameWithoutQuotes,DataSourceName)
Then, Use "YourCollectionNameWithoutQuotes" as DataSource to operate on PowerApps control which would help to remove the delegation warning message.
Hope it helps.

Best regards,
Sylvia

Was this reply helpful? Yes No
WarrenBelz 156,119 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BeccaSarah90 ,

Firstly, this should be Delegable

Filter( [@'MyList'], 'Assigned Internal Contact'.DisplayName = ComboBox1.Selected.DisplayName )

assuming you are dealing with a single choice in both 'Assigned Internal Contact' and ComboBox1 - is this the case ?

Also, what is the Items of ComboBox1 ?

Was this reply helpful? Yes No