Using &&& and || in LookUp

(0) Share

Report

Posted on by ImaKickUrAsh

Hello there!

I'm trying to perform LookUp on a "settings" table with multiple conditions & am observing strange behavior.

LookUp (
settings,
 dropdown1.Selected.Value in Column1.Value
 && dropdown2.Selected.Value in Column2.Value
 && dropdown3.Selected.Value in Column3.Value
 && (dropdown4.Selected.Value in Column4.Value || "All" in Column4.Value)
)

I'm trying to look up the record that matches the dropdowns to column values except in case of dropdown4, where the condition becomes an OR within the AND (all the other conditions must be met and either dropdown4's selected value is in column 4 OR "All" is in Column 4 - one or the other needs to return true). everything works right up until the last line.

Is my syntax correct for what I'm trying to do? Any suggestions?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

BhargavPatel 660 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ImaKickUrAsh Can you try removing ".Value" from all the column names?

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ImaKickUrAsh ,

Could you please share more details about your scenario? What data source is it? What are the types of the columns 1-4?

It seems these columns are all Choices columns allow multiple selections, if this is the case, you can also try below formula:

With( { wFilter: Filter(settings, dropdown4.Selected.Value in Column4.Value || "All" in Column4.Value) }, LookUp( wFilter, dropdown1.Selected.Value in Column1.Value && dropdown2.Selected.Value in Column2.Value && dropdown3.Selected.Value in Column3.Value ) )

Best regards,

Was this reply helpful? Yes No
ImaKickUrAsh 51 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I could not - they are multi-select fields & would throw errors when I removed .Value

Was this reply helpful? Yes No