EQ Null error bug

[MitchNet]

I have a Eq Null error message that appears in my app. It doesn't occur in the edit mode or preview mode of canvas. It only occurs when navigating to a screen for the first time on mobile or web based app, It can be cleared and the app runs fine but It is very annoying. If I navigate back from the screen and then return to it the error message doesn't show, even if I have not made any inputs.

I think it may relate to a dropdown input where the selected value is used in a different Text input with a Lookup(). Can this error occur because the Default value is not populating before the Lookup function executes?

Data source is Excel.

I have no idea why this is happening and I've spent most of the day trying to figure this out so any help would be appreciated!

 

[PG_WorXz10]

Hi @MitchNet ,

If possible try to bind the data with only non blank values.

[MitchNet · Accepted solution]

So I solved this problem by putting the drop down selection on the previous page. That way the dropdown.selected.item was there before the lookup() function tried to execute with a null value. It's kind of annoying seeing as I did set a default value for the drop down but obviously that does not populate before the Lookup() function executes.