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

Notifications

Announcements

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

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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard