Delegation using !IsBlank

(0) Share

Report

Posted on by firda59

372

Hi,

I used this formula to get value from different SP List,

First(Filter(
Filter(PPIC, !IsBlank('Production Order')),
'Production Order' = First(Filter('List Job Cikupa', Order = ProdOrder.Selected.Value)).'Production Order Induk'
)).'ID Product'

If I remove IsBlank, then I got error, but If I keep using that formula, I got delegation.

Can anyone suggest me another way? Thankyou!

Categories:

Connecting to Data

Dataflows

Using Apps Using Formulas

Connectors

General Questions

I have the same question (0)

All responses (19)

Answers (0)

ANB 7,213 Super User 2025 Season 2 on at

Like (0)

Report
Re: Delegation using !IsBlank

Hi @firda59 , Can you try this:

LookUp(PPIC, !IsBlank('Production Order') && 'Production Order' = LookUp('List Job Cikupa', Order = ProdOrder.Selected.Value).'Production Order Induk' ).'ID Product'

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

Re: Delegation using !IsBlank

@ANB

I still got delegation warning because of '!IsBlank' function.
Is there any solution? Thankyou!

Was this reply helpful? Yes No
ANB 7,213 Super User 2025 Season 2 on at

Like (0)

Report

Re: Delegation using !IsBlank

HI @firda59 , What is data type of 'Production Order'

Thanks,
ANB

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

Re: Delegation using !IsBlank

@ANB

data type is single line/text

Was this reply helpful? Yes No
ANB 7,213 Super User 2025 Season 2 on at

Like (0)

Report
Re: Delegation using !IsBlank

@firda59 , Can you try this:

EDITED:

LookUp(PPIC, 'Production Order' <> "" && 'Production Order' = LookUp('List Job Cikupa', Order = ProdOrder.Selected.Value).'Production Order Induk' ).'ID Product'

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
WarrenBelz 151,936 Most Valuable Professional on at

Like (0)

Report
Re: Delegation using !IsBlank

Hi @firda59 ,

Why are you bothering with IsBlank when it has to equal a value you have looked up on the other list

With( { _Order: Lookup( 'List Job Cikupa', Order = ProdOrder.Selected.Value ).'Production Order Induk' }, LookUp( PPIC, 'Production Order' = _Order ).'ID Product' )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

Re: Delegation using !IsBlank

@WarrenBelz

If I remove 'IsBlank', like your formula
I got this error

Thankyou

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report

Re: Delegation using !IsBlank

@ANB

I got delegation warning from '&&' function😔

Was this reply helpful? Yes No
WarrenBelz 151,936 Most Valuable Professional on at

Like (1)

Report
Re: Delegation using !IsBlank

@firda59 ,

I will leave you with @ANB here and answer your other question - Relational Lookups (looking up another list inside a filter) are not Delegable, hence my use of the With() statement to "pre-filter' this part. You can do this

With( { _Order: Lookup( 'List Job Cikupa', Order = ProdOrder.Selected.Value ).'Production Order Induk' }, With( { _Data: Filter( PPIC, 'Production Order' = _Order ) }, LookUp( _Data, !IsBlank('Production Order') ).'ID Product' ) )

Was this reply helpful? Yes No
ANB 7,213 Super User 2025 Season 2 on at

Like (0)

Report

Re: Delegation using !IsBlank

Hi @firda59 , @WarrenBelz is correct! Please use the code which is suggested by him. It is going to give you the same output.

Thanks,
ANB

Was this reply helpful? Yes No