News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps "eq null" error in a c...

Power Apps - Building Power Apps

Unanswered

"eq null" error in a combobox

(1) Share

Report

Report

Posted on by WorkingRicardo

749

    LookUp(ExcelTable; No_ = ComboBox1_1.Selected.No_);

I have this por DefaultSelectedItems property in order to auto-set whatever corresponds to whatever was selected on that Combobox 1_1.

Problem is, if nothing was selected I will get the dreaded "No_ eq null not supported". Meaning, the combobox cannot be empty.

I need a conditional that only runs that code if the Combobox1_1 is not blank, so that way I can avoid the error.

Any ideas? Thanks in advance

Categories:

Using Apps Using Formulas

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

mmbr1606 11,991 Super User 2025 Season 1 on at

Like (0)

Report
"eq null" error in a combobox

hey

you can try this in the defaultselecteditems:

If( IsBlank(ComboBox1_1.Selected.No_), {No_: "Default Value"}, // Substitute "Default Value" with an appropriate default or leave it blank as needed. LookUp(ExcelTable, No_ = ComboBox1_1.Selected.No_) )

please mark as verified answer if it helped
Anchov 1,984 on at

Like (0)

Report
"eq null" error in a combobox

You would need to do something like:

If(!Isblank(ComboBox1_1.Selected.No_), LookUp(ExcelTable; No_ = ComboBox1_1.Selected.No_));