Clarification: IsBlank and in are not delegated with lookup columns in SQL server (Access Web App)

(0) Share

Report

Posted on by Meneghino

6,949

Delegation does not work with lookup column types, such as the following (I get the bue i warning)

Filter('[Access].[MyTable]', IsBlank(MyLookUpColumn) )

Hence the documentation should clarify than not only data sources and functions must be delegable, but also column types must be delegable for delegation to work. Even better, please extend delegation to lookup columns, they are just integers after all...

From the documentation:

Filter, Search, and LookUp can be delegated.

Within the Filter and LookUp functions, the following can be used with columns of the table to select the appropriate records:

And (including &&), Or (including ||), Not (including !)
In
=, <>, >=, <=, >, <
TrimEnds
IsBlank
Constant values, which do not include context variables or collections

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Meneghino,

Thanks for the remindings.

I agree that documentation should make the explanation clear enough.

Regarding the Delegation, it explains the following:

"However, every data source is different, and not all of these are supported by every data source. Check for blue dot suggestions in your particular formula."

I will test the foreign Key column in SQL server (Microsoft Access Web Database?), and will collect this as a feature request once confirmed.

Thanks again.

Regards

Was this reply helpful? Yes No
Verified answer

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi Meneghino,

Update:

Under SQL server 2016, with the fomula below, filter will not work well.

Filter('[dbo].[Sales]',IsBlank(Product))

Not only the lookup column, but also the other columns are not supported here. I think the issue here should be the isblank function.

IsBlank( Value )

Value – Required. Value to test.

In function works:

If I have any misunderstandings, please let me know.

Regards

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-micsh-msft
Thank you for following up on this. Yes, you are right, IsBlank does not now seem to work with any column types.
Will you put forward as a feature request?
Thanks for the hard work.

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Meneghino,

Glad to help.

I will help to collect this from my side.

And if it is convenient, please also submit an idea on this in the PowerApp Idea forum.

Thanks for your understanding.

Regards

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (1)

Report
Copy link

Link copied!

Thanks, new idea here:
https://powerusers.microsoft.com/t5/PowerApps-Ideas/Extend-delegation-to-IsBlank/idi-p/13914

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (1)

Report
Copy link

Link copied!

Hi @v-micsh-msft, is there any update regarding the delegation of the in operator? Otherwise it seems impossible to do joins efficiently.
Thanks.

Was this reply helpful? Yes No