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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 155,752 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
ajithd6368 496 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks WarrenBelz,

It worked fine

rgds
AD

Was this reply helpful? Yes No