During the creation of my first function to be used with Power Automate I received this warning when attempting to use the 'Filter()' function. This was odd as I know this function IS delegable (The warning is saying it will become NON-delegable). The warning ended up being correct as my flow failed because it was trying to filter against a table with more than 1000 rows.
With some trial and error I found two comparisons in my filter that were causing this to occur:
1. Comparing a Yes/No choice field to true/false
myChoiceField = true
This will cause the filter to become non-delegable. In this cause you need to get the actual Yes/No value from your field. It needs to look like this:
myChoiceField ='My Choice Field (My Table)'.Yes
2. Using a 'Grandparent' lookup field (A lookup field to a lookup field)
In my table I have lookup field to a Header/Parent table which then does a lookup field to another table.
'Initial Lookup'.'Next Lookup'.GUIDField = GUID(GUIDValue)
To solve this it is easiest to create a GUID field on the table you are using in your 'Filter' with a formula:
Text('Initial Lookup'.'NextLookup'.GUIDField)
This will give you the GUID in a text field on your table. You can then make the comparison and your 'Filter' stays
delegable!
