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

[HansHeintz]

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?

[cchannon · Accepted solution]

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