LookUp Field Blank Check

(0) Share

Report

Posted on by LokeshCapita

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:

Building Power Apps

I have the same question (2)

All responses (7)

Answers (1)

rimatos on at

Like (0)

Report

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

Was this reply helpful? Yes No
LokeshCapita 15 on at

Like (0)

Report

Hi @rimatos
thisis how i am using

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

Was this reply helpful? Yes No
rimatos on at

Like (0)

Report

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

Was this reply helpful? Yes No
LokeshCapita 15 on at

Like (0)

Report

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

Was this reply helpful? Yes No
rimatos on at

Like (2)

Report

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

Was this reply helpful? Yes No
Verified answer

LokeshCapita 15 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Robert94 520 on at

Like (0)

Report

How did you do it exactly?

Was this reply helpful? Yes No