Delegation warning

(0) Share

Report

Posted on by fpsdf

I'm using the following code for this gallery.Items:

Switch(

Localsortcolumn,

"number",

SortByColumns(

Filter(

CREAT,

(IsBlank(FilterCountry) || COUNTRY_CODE = FilterCountry) , (IsEmpty(FilterTeams) || CREA_TEAM in FilterTeams.Value) , (IsEmpty(FilterStatuses) || STATUS in FilterStatuses.Value) , (IsBlank(FilterAnalyst) || CREDIT_ANALYST = FilterAnalyst) , (IsBlank(FilterDate) || NEXT_REVIEW_DATE <= FilterDate)

"CUSTOMER_NO",

If(

localsortascending,

SortOrder.Ascending,

SortOrder.Descending

)

It is a SharePoint list with 26000 records. Would you recommend a different approach?

Thank you!

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Localsortcolumn, "number", SortByColumns( Filter( CREAT, (IsBlank(FilterCountry) || COUNTRY_CODE = FilterCountry), (IsEmpty(FilterTeams) || CREA_TEAM in FilterTeams.Value), (IsEmpty(FilterStatuses) || STATUS in FilterStatuses.Value), (IsBlank(FilterAnalyst) || CREDIT_ANALYST = FilterAnalyst), (IsBlank(FilterDate) || NEXT_REVIEW_DATE <= FilterDate) ), "CUSTOMER_NO", If(localsortascending, SortOrder.Ascending, SortOrder.Descending) ) )
hi @fpsdf ,
try this:
Switch(


        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
    
              
                
                fpsdf
                14 
                
        
                
                
             
         

            
                
                        
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 






















 Like
a
(0)
                            

 





























    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        hey @anandm08 , thank you!

but there seems to be no difference between my code and yours... I'm still getting the same warning
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                        
                        
                  
                
              
            
          
        
        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
    
              
                
                Francisco_RM
                2 
                
        
                
                
             
         

            
                
                        
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 






















 Like
a
(0)
                            

 





























    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        SharePoint doesn't support the "in" clause as a delegated filter 😕
 
https://learn.microsoft.com/en-us/connectors/sharepointonline/#power-apps-delegable-functions-and-operations-for-sharepoint
                      
                    
                        
                        
                            




 





 






 





 


                        
                         
                      
                          
                       
                        
                            
                             
                              
                            
                            
                            
                            
                        
                        
                  
                
              
            
          
        
        
            
            
        
         
        
            
        
          
            
              
                
                  

                    
                    
                    
                        
                         
                         
                        
                    
                    
                      
                     
                      
                        





 

    


 
    
    
    
    
    
    
    
    
      

     

    
    
        
        
    

    
        
     

       

        
            
        

    

  
                        
                       
                            









 












 





 












 





 


  











 





 












 





 








 
    

  

 
    

    
      
        
        

         

         
        
            
            
             
                
                
            
            
        
        
        

        
    
              
                
                uwenagel
                382 
                
        
                
                
             
         

            
                
                        
                 
            

    


 on  at 
                        
                    
                        
                        
                        
                          
                            
                            
                            
                              










 






















 Like
a
(0)
                            

 





























    



 



 



Report
                        
                                
                                    

                                        

                                        
                                            Copy link
                                        

                                        Link copied!
                                    
                                
                          
                        
                      
                    
                  
                
              
              
                
                  
                    
                      
                        There is a common trick I use in this circumstance:
 
Instead of filtering the table direct you add an AddColums to the formula by just copying the ID into a new column (I call it IDS).
 
Switch(
 Localsortcolumn,
 "number",
 SortByColumns(
 Filter(
 AddColumns(
 CREAT,
 IDS,
 ID
 ),
 (IsBlank(FilterCountry) || COUNTRY_CODE = FilterCountry),
 (IsEmpty(FilterTeams) || CREA_TEAM in FilterTeams.Value),
 (IsEmpty(FilterStatuses) || STATUS in FilterStatuses.Value),
 (IsBlank(FilterAnalyst) || CREDIT_ANALYST = FilterAnalyst),
 (IsBlank(FilterDate) || NEXT_REVIEW_DATE <= FilterDate)
 ),
 "CUSTOMER_NO",
 If(localsortascending, SortOrder.Ascending, SortOrder.Descending)
 )
)
 
This way the data is loaded into memory and the delegation is gone.









 
                              
                            
                                
                                    
                                        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.


                    
                    
                    
                         
                                                                                       
                        
                    
                    
                     
                        
                          Join the conversation