Answered

First Filter causing delegation warning on SharePoint

(0) Share

Report

Posted on by BenScottWeb

This morning when creating a new app the "First" function seems to cause the delegation warning shown in the screenshot. Is this new expected behavior or is this a bug? Anyone else seeing the same?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
@BenScottWeb

Please try this code instead and let me know if the delegation warning goes away. LookUp should always be used in place of First + Filter because it downloads the data much faster

LookUp(ADM2Pass, Title="test', Title)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
BenScottWeb 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply I can confirm that using lookup resolves the issue.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This solved my problem, thank you so much for the post

Was this reply helpful? Yes No
pwagma 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Im trying to use this on a ComboBox, while taking the information from a Gallery. I'm using the property "DefaultSelectedItems".
It is only 1 item, always (selectmultiple on false).

I use the following function with delegation issues: First(Filter(Materiales, Gallery1.Selected.Tipo = Title)).Title and it works.
When I change for your solution, it doesn't work (result is not a table). LookUp(Materiales, Gallery1.Selected.Tipo = Title, Title).
If I use the [] to create an array with 1 option, then it shows this result, but it doesn't take the info from the list so it is not working properly.

Ideas?

Thanks

Was this reply helpful? Yes No
Mark999 7 on at

Like
a
(0)

Report
Copy link

Link copied!

This did not work for me. It still gives the delegation warning...

Was this reply helpful? Yes No