cancel
Showing results for 
Search instead for 
Did you mean: 

Delegate "in" operator for data sources

We need the ability to delegate the joining of data sources or collections (or a collection and a data source), using the "in" and "exactin" operators. Currently this is not delegated for SharePoint lists, and although documentation states SQL Server is delated, users experience contradicts this.

 

Links to related threads can be found here and here.

 

 

 

 

Status: New
Comments
Level 10

Hi @areid, fully agree!

According to the documentation this operator is currently delegated only for SQL Server and SalesForce data sources.

This post pertains to delegation of in.  I will test again and update that post.

Level: Powered On

Like to have this in CDS too

Level 8

This is really important when developing using SQL Server as there tends to be more normalization of data meaning more joined tables and  tests for membership

 

Currently the in operator as a test for membership is definitely not delegated to SQL Server which puts an enormous restrictions on data returned.

 

It does not seem to be good business practice to promote documentation stating that an important feature exists while leaving the users to struggle without the feature.

 

Level 10

@PhilDI think that the heat is off on delegation.  With the following technique you can bypass all the limitations:

https://baizini-it.com/blog/index.php/2018/05/10/powerapps-concurrently-returning-variables-and-mult...

KML
Level: Powered On

The "In" delegation doesn't work for SQL server

Level: Powered On

The "in" opperatore must be deligated!!!!!!

Level: Powered On

Just spent an hour trying to debug some weird behaviour - turns out it was this issue. I.e. SQL col IN (<list>) not being delegated, but importing a bunch of rows 😒. Flows aren't a nice programming paradigm, add a lot of uncessary complexity 😐

 

Docs https://docs.microsoft.com/en-us/connectors/sql/#powerapps-delegable-functions-and-operations-for-sq...