in scenarios like mine, do i need to use a related table (with an IncidentType text field) instead of a picklist? this way the filter is looking at a text field value in the related table.
Would you please share more information about the IncidentType Picklists?
For filter function to work, the formula part should be result in a boolean value.
This should work.
For option 4 you mentioned, I am a little confused about it. Would it be convenient for you to share any examples wihtin a formula?
As you can see above, the Filter expression evaluates a boolean predicate, but renders no records. with an EntityForm, you can see that entering an "H" does not filter the list of IncidentTypes (take my word that i chose IncidentType from the list).
Also, note that Distinct(Interview,IncidentType) does return the list of two options i expect.
As for item 4, i've added other examples to include the Key field (type string).
Also, i have added a DataTable because it behaves the same way as the other controls. BTW, did you guys notice that you cannot copy and paste a DataTable nor can you nudge them with cursor keys? Likewise with EntityForms.
I've added one unexpected phenom, as well: the two entityforms are identical; the only difference is that i type an "H" in the top one. This converts the strange string values for Key listed in the bottom form to the correct string values i expected in the first place.
Would you like me to ship my Picklist and Interview entity table to you?