cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EntsuP
Level: Powered On

Re: "in" operator as test of membership and its delegation

I am connected to azure SQL instance and it is NOT working. Well I have still under 500 rows, so I get just a warning.
James_Hellfeier
Level: Powered On

Re: "in" operator as test of membership and its delegation

Just ran into this issue myself, trying to Collect from a SQL Server using a Collection to Filter :

 

Collect ( Collection1 , Filter ( [dbo] , ID in Collection2.ID ))

 

Still getting the non-delegable flag and Powerapps telling me my 1-column (Collection2.ID) is not in fact a 1 column table ... And the documentation still says that "in" is delegable with SQL.