Expression "XXX eq null" is not supported.

(0) Share

Report

Posted on by rhendr12

Hi,

I get the following error message, though the canvas seems to work fine.

"The requested operation is invalid. Server Response. Expression "XXX eq null" is not supported."

I've three dropdowns. Two of them are dependent on the entry of one other. The 1st dropdown has the following code in Items:
Sort(Distinct(ExcelDataTable, Column1),Result) >> DataCardValue14

The 2nd dropdown (relates to the first) and 3rd dropdown(relates to the second) have these error messages. Code in Items as per below:
2: Distinct(Filter(ExcelDataTable, Column1 = DataCardValue14.Selected.Result),Column2) >> DataCardValue15

3: Distinct(Filter(ExcelDataTable, Column2 = DataCardValue15.Selected.Result),Column3) >> DataCardValue16

The default values were initially on Parent.Default. I tried to set default values of the most picked, but that didn't solve the issue. Also the error seemed to occur recently (not from the start).

I tried several solutions opted in other discussions on this error, but unfortunately without success. Anyone any idea how to solve this error?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It looks like your DataCardValue16 doesn't refer to 15, it refers to 14, try changing that to:

Distinct(Filter(ExcelDataTable, Column2 = DataCardValue15.Selected.Result),Column3)

Was this reply helpful? Yes No
rhendr12 10 on at

Like (1)

Report
Copy link

Link copied!

Sorry, that was a copy/paste mistake. In the app this is correct. Corrected in the initial support request.

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Ok, then looking at the error it looks like it doesn't like getting a blank/null value, which I think will be happening when there is no value selected in one of the related items, so we can do a check before hand and not have it do anything is there is a blank value in the selected item.

DataCardValue14

Sort(Distinct(ExcelDataTable, Column1),Result)

DataCardValue15

If( !IsBlank(DataCardValue14.Selected.Result), Distinct(Filter(ExcelDataTable, Column1 = DataCardValue14.Selected.Result),Column2) )

DataCardValue16

If( !IsBlank(DataCardValue15.Selected.Result), Distinct(Filter(ExcelDataTable, Column2 = DataCardValue15.Selected.Result),Column3) )

Was this reply helpful? Yes No
rhendr12 10 on at

Like (1)

Report
Copy link

Link copied!

That seemed to do the trick. I've seen this solution before, but I guess I didn't apply it the right way.

Thanks for your help! Lot's appreciated!

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Happy I could help @rhendr12 - there's so many ways to do the same things in PowerFx so sometimes it's hard to figure out what you need!

Was this reply helpful? Yes No