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 issue
Power Apps
Answered

Delegation issue

(0) ShareShare
ReportReport
Posted on by shoebwk 118

Hi,

 

Need help to remove the delegation warning triangle on the image gallery due to the following function

Filter(MobilityCars,VarCarRecord.BaseModel in Lower(Name))

I am filtering the Images in the gallery by checking on BaseModel text which is a part of the Name column. eg.

BaseModel ="Corolla" Name=" Toyota Corolla 1.4 TD"

Delegation error.png
Categories:
Building Power Apps
I have the same question (0)
  • KrishnaV Profile Picture
    KrishnaV 5,023 on at

    Hi @shoebwk ,

     

    In is not a delegable operator:
    try this:

    Filter(MobilityCars,StartWith(VarCarRecord.BaseModel,Lower(Name)))

     
    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Regards,
    Krishna
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

  • shoebwk Profile Picture
    shoebwk 118 on at

    Still the warning plus the formula is not working properly

     

    startwith.png
  • KrishnaV Profile Picture
    KrishnaV 5,023 on at

    Hi @shoebwk ,

     

    my bad try this:

    Filter(MobilityCars,StartsWith(Lower(Name),VarCarRecord.BaseModel)) // I am assuming Name is the column in the datasource

     
    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Regards,
    Krishna
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

  • shoebwk Profile Picture
    shoebwk 118 on at

    Still the same warning. Name is the column in sharepoint document library.

  • KrishnaV Profile Picture
    KrishnaV 5,023 on at

    Hi @shoebwk,

     

    What is the value you have in ??

    VarCarRecord.BaseModel

     Also please share the warning message in a screenshot.


    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Regards,
    Krishna
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

     

  • Pstork1 Profile Picture
    Pstork1 69,024 Most Valuable Professional on at

    Based on the sample values you provided there is no way to do this without getting a delegation warning.  Since the target you are looking for is contained INSIDE name you won't be able to use StartsWith() successfully.  Is there anything else you can filter on to get the list below the 500 record limit and then filter using the IN.  You'll still get a warning, but since you are pre-filtering you can safely ignore the warning.  Your only other choice is to add a column to the data source that contains the base model for each image.

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

    @shoebwk

    How many items are in your MobilityCars list and how many do you anticipate it will grow to?

  • shoebwk Profile Picture
    shoebwk 118 on at

    My List will never grow beyond 20-25 models.

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

    Hi @shoebwk 

    You can safely ignore the warning.  Delegation will only be a problem if you have more than 500 items in your list. If it still really bothers you, then in the OnVisible property of the screen containing your image gallery, put ClearCollect(colMobilityCars, MobilityCars) and then use either your original formula 

     

    Filter(colMobilityCars,VarCarRecord.BaseModel in Lower(Name))

     

    or

     

    Search(colMobilityCars,VarCarRecord.BaseModel,"Name")

     

    as the Items property of the gallery.  

  • KrishnaV Profile Picture
    KrishnaV 5,023 on at

    Hi @shoebwk ,

     

    Yes, since it is a very minimal number you can happily ignore that.


    I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

    Regards,
    Krishna
    If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

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