Explain to me please!

[Jeff_Hager]

I’m too mentally fried right now to try it, but is it safe to assume that the new column to column compare on a filter will not work to compare choice sheet columns to form column values?

Based on this post:

Wrong data context for new dynamic (3 dot) Choice filters in Forms

The new dynamic options for the right side of filter conditions is awesome, however it is pulling in the wrong data context for Choice/List components in Forms. I can only compare a value for the current list item against a value in that same item, which is not really helpful at all. That could be done with a simple If/Then/Else in the data editor. Instead, the right side filter options should be pulling from the Form’s data context which enables things that were difficult or impossible to do pr…

If that was possible, then it could be done in the form. Otherwise, like @ThinhDinh said, I think we are stuck making the choices outside of the form using user specific columns and a relation.