Eq Null is not supported

[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.

[AJ_Z]

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.

[SteCos]

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.

[AJ_Z · Accepted solution]

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"))

[SteCos]

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

[AJ_Z]

You are very welcome I am happy to help 🙂