web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Delegation work around
Power Apps
Answered

Delegation work around

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello All,

 

i am facing a delegation warning with the code below. Can anyone please tell me how i can remove the delegation? In the code i am filtering my request form with for user by matching user email id and also by checking user user admin. I also have a search box which allows to search for unique id and Title and status column. I get a delegation warning, how can i remove the delegation warning?

SortByColumns(
 Filter(
 'SAP User Request Form',
 And(
 Or( Lower('Email Id') = Lower(useremail) , Lower(useremail) in Lower(
 Concat(
 admin.Email,
 ","
 )
 )) &&
 
 Or(
 (TextSearchBox1.Text in 'Unique ID'),
 (TextSearchBox1.Text in Title), (TextSearchBox1.Text in status.Value) ) 
 
 )
 ),
 "Created",
 Descending
)

  

Categories:
I have the same question (0)
  • Iamglt Profile Picture
    316 on at

    Hi Jayant2

    How many records will this filter extract?  If its only a small number you can remove the delegation warning using the With statement.  Take a look at Warren Belz's blog and use the scenario that matches your case:

    With() Statement managing Delegation – Practical Power Apps

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @Anonymous 

    The “in” operator is not delegatable in Sharepoint.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @Drrickryp i need to match the email in a multiselect people picker. How can i then filter out without using in. 
    any idea?

  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    Please see this post. It explains in detail how to use people picker in PowerApps https://www.spguides.com/create-people-picker-in-power-apps/  step by step.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 463

#2
WarrenBelz Profile Picture

WarrenBelz 364 Most Valuable Professional

#3
11manish Profile Picture

11manish 275

Last 30 days Overall leaderboard