Lookup will not work with multiple conditions.

(0) Share

Report

Posted on by ajithd6368

496

Hi ,

I'm having below lookup statement on Onchange , It worked perfectly with one condition but with two conditions , it doesn't do the validation . There are no syntax errors . Pls help me

If(IsBlank(LookUp(AssetTransactions, AssetNumber=Self.Text && Completed.Value="Complete")),UpdateContext({RecValid: false}),UpdateContext({RecValid: true}),UpdateContext({MakeItRed:!MakeItRed}))

With only one condition it's working fine

If(IsBlank(LookUp(AssetTransactions, AssetNumber=Self.Text )),UpdateContext({RecValid: false}),UpdateContext({RecValid: true}),UpdateContext({MakeItRed:!MakeItRed}))

rgds

Categories:

General Questions

All responses (2)

Answers (1)

ajithd6368 496 on at

Like (0)

Report

Re: Lookup will not work with multiple conditions.

Thanks WarrenBelz,

It worked fine

rgds
AD
Verified answer

WarrenBelz 146,981 Most Valuable Professional on at

Like (1)

Report
Re: Lookup will not work with multiple conditions.

Hi @ajithd6368 ,'

Firstly, you have three conditions on the IF statement - the last one will never trigger (I think you are trying to do the below). You can also do this assuming AssetNumber is a Text field (not numeric) and Completed is a Choice field.

UpdateContext( { RecValid: !IsBlank( LookUp( AssetTransactions, AssetNumber = Self.Text && Completed.Value = "Complete" ) ) } ); UpdateContext({MakeItRed: !MakeItRed})

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.

Visit my blog Practical Power Apps