Population of one field affecting visibility of another

[Scott_Nesbitt]

I have this lookup field:

It does not appear in a form unless a different field in the form is populated.  Why would this be?  I do not have any kind of show_if logic.  Also, it appears fine if I make it a regular enum field that does not do a lookup

Thanks,

Scott

[AleksiAlkio · Accepted solution]

It sounds like you have the same kind of formula in some of your columns before. When using syntax TableName[ColumnName], and you have them more than one, it creates a dependent dropdown. To avoid this, write it like.. SELECT(TableName[ColumnName],TRUE)

[Scott_Nesbitt]

That fixed it, thanks so much.

In case anyone else is interested, the documentation on this is here.