Unanswered

Delegation warning on items in gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Filter( 'Submitted Requests', If( IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = "All", true, 'Requestor Country' in ComboBox1.SelectedItems ) && If( IsBlank(Filter_10.Text), true, Filter_10.Text in 'Submitted Date' ) && If( IsBlank(Filter_3.Text), true, Filter_3.Text in Title )&& If( IsBlank(Filter_4.Text), true, Filter_4.Text in 'Requestor Name') )

This is my items in the gallery. The problem is I have a delegation warning for large data sets. I know that if I used a collection it would go away. The problem is that when I submit a form the collection does not update unless onstart is pushed and the item will not be in the gallery until I reload the app. Is there a way I can alter the collection portion so it updates fast enough to get rid of the delegation warning?

Categories:

Building Power Apps

All responses (10)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

Try

With({wfiltered:Filter( 'Submitted Requests', If( IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = "All", true, 'Requestor Country' in ComboBox1.SelectedItems ) && If( IsBlank(Filter_10.Text), true, Filter_10.Text in 'Submitted Date' ) && If( IsBlank(Filter_3.Text), true, Filter_3.Text in Title )&& If( IsBlank(Filter_4.Text), true, Filter_4.Text in 'Requestor Name') )}, wfiltered )

as the Items property of your gallery. I have not tried to see if your formula works or not (I'm assuming it does), but this will eliminate the delegation warning.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp I still have the warning with that
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Hmm, I'm afraid that the "in" operator is the problem. BTW just how big is your dataset of Submitted Requests?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It could be thousands and is there a way to alter it? @Drrickryp
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Is there a way to fix this and remove the in operator @Drrickryp
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Only if you can use StartsWith() in your filter instead of "in". To avoid delegation errors you can only use functions that are delegatable in SharePoint with large datasets. If you switch to dataverse or sql from SharePoint you can use Search() and it is delegatable for those datasources
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have to use sharepoint but when I tried the with you suggested up there I still had the delegation errors @Drrickryp
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Could you post your current formula please as well as the type of fields in your list, ie. single line of text, choice, lookup, etc?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Filter(
'Submitted Requests',
If(
IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = "All",
true,
'Requestor Country' in ComboBox1.SelectedItems
) && If(
IsBlank(ComboBox1_10.Selected.Result) || ComboBox1_10.Selected.Result = "All",
true,
Application in ComboBox1_10.SelectedItems
)&& If(
IsBlank(ComboBox1_11.Selected.Result) || ComboBox1_11.Selected.Result = "All",
true,
'Process Step' in ComboBox1_11.SelectedItems
) && If(
IsBlank(ComboBox1_12.Selected.Result) || ComboBox1_12.Selected.Result = "All",
true,
Status in ComboBox1_12.SelectedItems
)&&
If(
IsBlank(Filter_14.Text),
true,
Filter_14.Text in 'Submitted Date'
) &&
If(
IsBlank(Filter_4.Text),
true,
Filter_4.Text in 'Request Name'
))
The fields are single, multiline and date @Drrickryp
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

As long as your formula contains the "in" operator, you will always get a delegation warning because this operator is not delegatable in SharePoint. You could check @WarrenBelz 's blog https://warrenbelz.blogspot.com/2020/08/power-apps-delegation-is-word-not.html to see if there is a suggestion there that could help you.