web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Delegation using !IsBlank
Power Apps
Unanswered

Delegation using !IsBlank

(0) ShareShare
ReportReport
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:
Building Power Apps
  • ANB Profile Picture
    ANB 7,252 Super User 2026 Season 1 on at

    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

  • firda59 Profile Picture
    firda59 372 on at

    @ANB 

     

    I still got delegation warning because of '!IsBlank' function.

    Is there any solution? Thankyou!

  • ANB Profile Picture
    ANB 7,252 Super User 2026 Season 1 on at

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

     

    Thanks,

    ANB

  • firda59 Profile Picture
    firda59 372 on at

    @ANB 

     

    data type is single line/text

  • ANB Profile Picture
    ANB 7,252 Super User 2026 Season 1 on at

    @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

  • WarrenBelz Profile Picture
    WarrenBelz 156,526 Most Valuable Professional on at

    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

  • firda59 Profile Picture
    firda59 372 on at

    @WarrenBelz 

     

    If I remove 'IsBlank', like your formula

    I got this error

    firda59_0-1696920920975.png

     

    Thankyou

  • firda59 Profile Picture
    firda59 372 on at

    @ANB 

     

    I got delegation warning from '&&' function😔

  • WarrenBelz Profile Picture
    WarrenBelz 156,526 Most Valuable Professional on at

    @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'
 )
)

     

  • ANB Profile Picture
    ANB 7,252 Super User 2026 Season 1 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 394 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 324 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans