Delegation warning on filter function

(0) Share

Report

Posted on by CU25062156-1

Hi everyone,

I am using Filter function to filter out the data from my datasheet with 2 conditions in it and was having the Delegation warning error. The code will work fine and show the result if I filter out with single column but not for both of the conditions. Could anyone help me to resolve it please? Thank you very much for your helps

Kind regards,

Categories:

Error handling

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

11manish 3,788 on at

Like
a
(0)

Report
Copy link

Link copied!
The delegation warning is most likely caused by the Author comparison or by treating FollowUp as text instead of a Boolean. First, confirm that FollowUp is a

Yes/No column and compare it to true rather than "true". If Author is a Person column (as it commonly is in SharePoint), compare against Author.Email =

User().Email instead of User().FullName. This approach is more reliable and has better delegation support.

If you're still seeing the warning, please let me know:

What is your data source? (SharePoint, Dataverse, SQL, Excel, etc.)

What is the data type of the Author column? (Person, Text, Lookup, etc.)

With those details, I can recommend the most efficient delegable formula.

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @CU25062156-1,

I will assume here you are using SharePoint (that is the only data source that has Person fields) and that FollowUp is a Text field (not a Yes/No) as you have mentioned that the query works on the single criteria.

Also Author is the alternate name for 'Created by' and this is a Person field. You can use
Filter( Records, FollowUp = "true" && Author.FullName = User().FullName )

if you do not have two identically named people in your tenant, otherwise use
Filter( Records, FollowUp = "true" && Author.Email = User().Email )

Also if FollowUp is a Yes/No column, then do this
Filter( Records, FollowUp && Author.Email = User().Email )

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

1 people found this reply helpful.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU25062156-1,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
CU25062156-1 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi WarrenBelz. Apologize, I tried your suggestions after seen it and forgot to return back. It worked for me now. Thank you very much all your helps

Hi 11manish, thank you for your information. It all good now.

Was this reply helpful? Yes No