Answered

Eq Null is not supported

(2) Share

Report

Posted on by SteCos

Hi Guys - I wonder if anyone can help with the below error message? The app works fine when the error message is cleared. I know it has something to the code below that I have in the Area field... Both the area and store data are taken from a different source from the rest of the fields and the store field is dependent on the area field selected.

The code I have in the area field is

SortByColumns(Distinct(Table2,Area),"Result")

Any help to resolve would be greatly appreciated.

Screenshot 2022-03-28 223053.jpg

Categories:

Error handling

I have the same question (0)

All responses (9)

Answers (1)

Sort by

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Does the error disappear when you select an area in DD_Area as it looks like the store error is saying it expects a value there based on the filter in order for it to work.

Was this reply helpful? Yes No
SteCos 36 on at

Like (1)

Report
Copy link

Link copied!

Yeah the error message disappears once an area is selected but when the app is live the error message shows up when users navigate onto the form.

Was this reply helpful? Yes No
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (3)

Report
Copy link

Link copied!
Try this:

If(IsBlank(DD_Area.Selected.Result),SortByColumns(Distinct(Table2,Site),"Result"), SortByColumns(Distinct(Filter(Table2,Area = DD_Area.Selected.Result),Site),"Result"))

or this and let me know if you get your desired result:

If(!IsBlank(DD_Area.Selected.Result),SortByColumns(Distinct(Filter(Table2,Area = DD_Area.Selected.Result),Site),"Result"))

Was this reply helpful? Yes No
SteCos 36 on at

Like (1)

Report
Copy link

Link copied!

The first one seems to have worked! Thanks for your help 🙂

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You are very welcome I am happy to help 🙂

Was this reply helpful? Yes No
adbryson 23 on at

Like (1)

Report
Copy link

Link copied!

Second option worked for my situation, thanks @AJ_Z !

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Glad to be of assistance 🙂

Was this reply helpful? Yes No
To_W 4 on at

Like (0)

Report
Copy link

Link copied!

Hello,

i have a similar problem with this string:
Filter(Lagerbestand;Kunde=Dropdown1_1.SelectedText.Value)
andthis:
LookUp(Lagerbestand;Bezeichnung=Dropdown1_2.SelectedText.Value).Teilenummer
but I am too stupid to adapt the If function to my code 😞
In both cases, I am refering to an "earlier" dropdown. My table is in excel.

I think the first solution is suitable for me, maybe someone could help me with the If funktion?

Was this reply helpful? Yes No
To_W 4 on at

Like (0)

Report
Copy link

Link copied!
Ok, ChatGPT was helping 🙂
If(IsBlank(Dropdown1_1.SelectedText.Value);Lagerbestand;Filter(Lagerbestand;Kunde=Dropdown1_1.SelectedText.Value))

Was this reply helpful? Yes No