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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / LookUp Field Blank Check
Power Apps
Answered

LookUp Field Blank Check

(0) ShareShare
ReportReport
Posted on by 15

I got Payment Entity Which has  look up  field of Organisation Entity.i want to Blank Check on Organisation Field 

I tried Isblank and Len Functions. Any Help Much Appreciated

Categories:
I have the same question (2)
  • rimatos Profile Picture
    Microsoft Employee on at

    Hi @LokeshCapita ,

     

    Could you show how you are using the IsBlank function to evaluate if the Organization field is empty? Depending on how the data is structured it could be something as simple as this:

     

    Filter(Payment,IsBlank(Organisation))

     

    The documentation for this function can be found in more detail here.

     

     

    Let me know if this answer helped you move forward!

     

    Regards,

    Ricardo

  • LokeshCapita Profile Picture
    15 on at

    Hi @rimatos 

    thisis how i am using

     

    If(IsBlank(ModelDrivenFormIntegration].Item.Organisation),Navigate(ConfirmManual_Error,Transition.None)

  • rimatos Profile Picture
    Microsoft Employee on at

    Hi @LokeshCapita ,

     

    I've made a slight change to the function you provided me in the previous reply.

     

    Could you try it now on your side? If it still fails could you show me a print of the error that you get?

     

    If(IsBlank(ModelDrivenFormIntegration.Item.Organisation),Navigate(ConfirmManual_Error,Transition.None)

     

     

    Regards,

    Ricardo

  • LokeshCapita Profile Picture
    15 on at

    hi @rimatos 

    this is my full code


    If(IsBlank(ModelDrivenFormIntegration.Item.Organisation),Navigate(ConfirmManual_Error,Transition.None),
    'ConfirmLatePaymentPerfomBoundAction'.Run(ModelDrivenFormIntegration.Item.'Late Payment');Navigate(ConfirmManualMatch_Success,Transition.None))

     

    when i am tring this its going only to error screen even though my organisation field is not blank .its not  executing performbound action

  • rimatos Profile Picture
    Microsoft Employee on at

    Hi @LokeshCapita ,

     

    So the way the IsBlank function works is it tests for a blank value or an empty string. The test includes empty strings since some data sources and controls use an empty string when there is no value present. My suggestion would be to try and test specifically for a blank value using if( Value = Blank(), ... instead of IsBlank.

     

    Another function you could try is the  IsEmpty function, which tests whether a table contains any records, and in this situation could also help to unblock you.

     

    You can consult on both these functions here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-isblank-isempty#description

     

     

     

    Hope this helps you move forward!

     

    If you are still struggling after attempting these workarounds, I would suggest raising a ticket with Microsoft Support from your admin portal: https://admin.powerplatform.microsoft.com/support

     

     

    Regards,

    Ricardo 

  • Verified answer
    LokeshCapita Profile Picture
    15 on at

    hi @rimatos  

    thanks for your help .some how i manged to fix this problem by creating variable and assiagning them all organisations .and doing isblank check on that variable.its working now

  • Robert94 Profile Picture
    520 on at

    How did you do it exactly?

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 505

#2
WarrenBelz Profile Picture

WarrenBelz 502 Most Valuable Professional

#3
Haque Profile Picture

Haque 324

Last 30 days Overall leaderboard