Can you hide the other names on a Dereference dropdown

[Dan_Oliphant]

Can you have a dereference without having the list to choose from. In other words, I would like the other users not to be able to see the other names on the list

[Steve]

Yep! Set the Valid If expression to an AND() or OR() expression that evaluates to TRUE if the manually-entered value is valid. For instance, if the column accepts a Ref to the RowKey column of the MyTable table, you could use either:

AND(IN([_THIS], MyTable[RowKey]), TRUE)

or:

OR(IN([_THIS], MyTable[RowKey]), FALSE)

Pay careful attention to the differences in the above.

[Dan_Oliphant]

Steve:

AND(IN([_THIS], MyTable[RowKey]), TRUE)

Thanks for the response. I can’t seem to get this to work. Perhaps I didn’t explain the situation correct. I would like the dropdown on the form of the REF to not show all the different options. I just want the person to have to type in their name.

[Steve]

What did you try, and what happened?