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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Delegation error in Ed...
Power Apps
Answered

Delegation error in Edit form Filter

(0) ShareShare
ReportReport
Posted on by KrishnaV 5,023

Hi Team,

 

I am experiencing a strange issue when I am trying to apply a Filter for Edit form. 
Filter Error.png

 

Follow the below steps to reproduce the error:

  1. Create a SharePoint with one lookup column with a multi-selection enable on it.
  2.  Now create a simple screen in PowerApps and refer the lookup to the dropdown control as below

 

Choices(SampleList.'LKP Column').Value​

 

  • Now add an edit form and apply the below formula

 

First(Filter([@SampleList],ddlLookup.Selected.Value in Concat('LKP Column',Value&";")))​

 

I know that In is not a delegable function in PowerApps with SharePoint list. Since my requirement is to get the selected dropdown in the multi-select lookup column I am using this.


I will be really thankful if one of you @mdevaney , @v-xida-msft, @v-bofeng-msft can help me with this issue.

 

Regards,

Krishna

Categories:
Building Power Apps
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 156,384 Most Valuable Professional on at

    Please disregard I thought I had a solution but not quite

     

     

     

  • KrishnaV Profile Picture
    KrishnaV 5,023 on at

    sorry @WarrenBelz none of them worked I see the error message as :
    Delegation Error1.png

     

    Regards,

    Krishna

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 156,384 Most Valuable Professional on at

    @KrishnaV ,

    I realised that just after I posted and deleted shortly after (see below). You will have difficulty with this one unless you can collect under 2000 records and then query that, or maybe this post of mine on large collections may be useful.

  • KrishnaV Profile Picture
    KrishnaV 5,023 on at

    Hi @WarrenBelz ,

     

    So what you mean I can't use the filter if my list is more than 2000 for this requirement? 

     

    Regards,

    Krishna

  • WarrenBelz Profile Picture
    WarrenBelz 156,384 Most Valuable Professional on at

    Hi @KrishnaV ,

    No - In is not Delegable. 
    The only real workarounds are

    • Do the big collection I have mentioned
    • Collect a working data set under 2000 with another (Text or Numeric) Delegable filter (then In will work on the collection)
    • If the records are all in the newest 2000, Collect with the list sorted ID Descending and get the newest 2000 records.

    BTW, I have been impressed with some of your solutions - welcome to the forum.

     

    Please click Accept as solution 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 giving it Thumbs Up.

  • KrishnaV Profile Picture
    KrishnaV 5,023 on at

    Hi @WarrenBelz ,

     

    Thank for your kind words and support I am just coming in your footprints to see the light at the end of the tunnel (the technology tunnel 😊 😊 

    I am not quite ready to load thousands of records as this app is using by both mobile and desktop users. So I am a little uncomfortable using these collections approach. 

    Let me see if I can build any other workaround for this.

     

    Regards,

    Krishna

  • Verified answer
    KrishnaV Profile Picture
    KrishnaV 5,023 on at

    Hi Team,

     

    I have resolved this issue as below:
    I have created a single line of text column in my list and populating that value with the selected values in the choice filed at the time of submitting a new entry. Now in my new entry, I am selecting the query against that column/field.
    Note: I have indexed that single line of text column so I can filter even if the list is more than 10K.

     

    Thank you all for your time and help @WarrenBelz 

     

    Regards,

    Krishna

  • martatracik Profile Picture
    martatracik 297 on at

    hi, i tried to use your solution with index column. so i created an index column in sharepoint list that is a source of lookup column. not sure how now i can use it as within my filter function in text input field. 

    Could you please help me?

     

    LookUp(
 Filter(RequestVLU, Text(BankNo) = DataCardValue10.Selected.Value),
 true
).BankName

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 401 Most Valuable Professional

#2
11manish Profile Picture

11manish 201 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans