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 / Alternatives of clear ...
Power Apps
Answered

Alternatives of clear collect- clearcollect doesn't support deleagate

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

is there any alternative of clear collect. clear collect doesn't support delegate and limit of records which will display will be 2000.

 

I am using clear collect to store filter data.


ClearCollect(paymentrequest,'Payment Requests');
ClearCollect(SearchfilterDashBoardData,Filter( paymentrequest,Status.Value <> draft,If(!IsBlank(txtPaymnetRequestId_1.Text),PaymentRequestID=txtPaymnetRequestId_1.Text,true ),
If(!IsBlank(cmb_office.Selected.ID),Office.Id in cmb_office.SelectedItems.ID,true),
If(!IsBlank(cmb_Status.Selected.Value),Status.Value in cmb_Status.SelectedItems.Value,true),
If(!IsBlank(cmb_entity.Selected.EntityName),Entity.Value in cmb_entity.SelectedItems.EntityName,true)));

 

After this i have used this collection in items property of gallery

 

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

    Hi @Anonymous ,'

    This is nothing to do with ClearCollect, you have several non-Delegable filters in your code

    ClearCollect(
 paymentrequest,
 'Payment Requests'
);
ClearCollect(
 SearchfilterDashBoardData,
 Filter(
 paymentrequest,
 Status.Value <> draft, //** <> not Delegable
 If(
 !IsBlank(txtPaymnetRequestId_1.Text),
 PaymentRequestID=txtPaymnetRequestId_1.Text,
 true
 ),
 If(
 !IsBlank(cmb_office.Selected.ID),
 Office.Id in cmb_office.SelectedItems.ID, //** in not Delegable
 true
 ),
 If(
 !IsBlank(cmb_Status.Selected.Value),
 Status.Value in cmb_Status.SelectedItems.Value, //** in not Delegable 
 true
 ),
 If(
 !IsBlank(cmb_entity.Selected.EntityName),
 Entity.Value in cmb_entity.SelectedItems.EntityName, //** in not Delegable
 true
 )
 )
)

    There may be some workarounds depending on the number of items in your data and how many can be isolated with Delegable filters. I have written a couple of blogs on this - Delegation in general and using the With() filter. Although they are SharePoint related, most will apply to you. Please have a read of them and I will be happy to elaborate further when you work out if they can possibly assist you.

     

    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.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview- As per this documentation clear collect is non delegable function.  In and <> can be delegated

     

    I am not getting any delegate warning also. why is it so?

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

    @Anonymous ,

    I do not know your data source and was referring to SharePoint, however have another read of my blog on Delegation - there are ways of collecting many more than 2,000 records explained in it.

    Also your link to the document does not work.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Thanks Warren,

     

    I am using sharepoint list as data source.  I have tried to use "=" operator instead of in, but it's not working. any suggestion on it and what operator i can use as replacement of <>

     

     

    please refer this link for documentation - https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#delegable-data-sources

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

    Thanks @Anonymous ,

    I can tell you (despite what that document says) that neither in or <> are Delegable in SharePoint, however looking at it again (I missed this on first response) I see now why you are not getting a Delegation warning as you have tried to collect the list first, then filtered the collection, so you will only be filtering the first 500-2000 (depending on your settings) items from the list.

    Firstly,

    • How many items are in your list?
    • How many do not have the Status of Draft and what are the other Status values?
    • Are your combo boxes single or multi-select?

    The main issue you have is the true statement when any of the controls are blank, meaning you want all the list.

     

    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.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at
    • If in or <>  are not delegable in sharepoint. what is alternative available?
    • If i have collected records first in list. It will collect only first 2000 records? it means collect is also non delegable?
    • items in list are more than 2000
    • Around 500 items has status Draft.
    • Other Status are like Pending Approval,Pending checks, sent for payment e.t.c
    • We are using multi select combo.
  • WarrenBelz Profile Picture
    WarrenBelz 156,386 Most Valuable Professional on at

    @Anonymous ,

    I am a user like you trying to help you through this. SharePoint is what it is (and so are Collections) and there are things you simply cannot do exactly the way you want to.

    How many more than 2,000 are in the list that are not draft?

    You will see in the blogs I referenced that there are possible workarounds, but only within certain limits.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Thanks warren

     

     

    around 1500 records are not draft

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

    Thanks @Anonymous ,

    You have also marked one of your posts as the solution, but anyway, this will get you up to 2,000 records (providing you have your settings on this) with the top filter. You will have to add in any other Status values you have not mentioned.

     

    With(
 {
 wPayReq:
 Filter(
 'Payment Requests'
 Status.Value = "Pending Approval" ||
 Status.Value = "Pending checks" ||
 Status.Value = "Sent for payment"
 )
 }, 
 ClearCollect(
 SearchfilterDashBoardData,
 Filter(
 wPayReq, 
 If(
 !IsBlank(txtPaymnetRequestId_1.Text),
 PaymentRequestID=txtPaymnetRequestId_1.Text,
 true
 ),
 If(
 !IsBlank(cmb_office.Selected.ID),
 Office.Id in cmb_office.SelectedItems.ID, 
 true
 ),
 If(
 !IsBlank(cmb_Status.Selected.Value),
 Status.Value in cmb_Status.SelectedItems.Value, 
 true
 ),
 If(
 !IsBlank(cmb_entity.Selected.EntityName),
 Entity.Value in cmb_entity.SelectedItems.EntityName, 
 true
 )
 )
 )
)

     

     

    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.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Thanks Warn. I tried the solution you provided. bu getting a lot of errors.

     

    vandana_0-1598867445604.png

     

     

    vandana_1-1598867547966.png

     

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 379 Most Valuable Professional

#2
11manish Profile Picture

11manish 203 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