cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HansHeintz
Post Patron
Post Patron

Filter dataverse table using "in" works but "not in" delegation error and not working

This filter in an items propery of o combobox works and no errors

 

 

Filter([@ProtocolItem];ProtocolItem[@ProtocolItem] in PresentProtocolItems.ProtocolItem)

 

 

But this: delegation warning AND not working

 

Filter([@ProtocolItem];!(ProtocolItem[@ProtocolItem] in PresentProtocolItems.ProtocolItem))

 

ProtocolItem is table and PresentProtocolItems is collection with records from that table. Both far < 500 items

 

Resolve?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
cchannon
Super User
Super User

First, this is a PowerApps issue, so in the future you should probably post it on that forum rather than the Dataverse one.

 

That said, delegation warnings are common in powerapps, although the product team is improving this all the time and there are far far fewer now than there used to be. To overcome delegation warnings, you need to set your delegation threshold higher or push your query out to a separate service (such as powerautomate) which does not have the same delegate limits.

 

Understand delegation in a canvas app - Power Apps | Microsoft Docs

View solution in original post

1 REPLY 1
cchannon
Super User
Super User

First, this is a PowerApps issue, so in the future you should probably post it on that forum rather than the Dataverse one.

 

That said, delegation warnings are common in powerapps, although the product team is improving this all the time and there are far far fewer now than there used to be. To overcome delegation warnings, you need to set your delegation threshold higher or push your query out to a separate service (such as powerautomate) which does not have the same delegate limits.

 

Understand delegation in a canvas app - Power Apps | Microsoft Docs

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (1,815)