Compare a field to all entries of a value list

[mdavis6537]

Hello,

 

I am wondering if it is possible via calculation to compare a single field with all options in a value list? I am using this as a portal filter. I have several portals on a layout, all from the same table that use different value lists for selection. I only want to display the active records in each portal from their respective value list that was used.

 

I am trying to use this function, but it doesnt work. 

 

Each Portal Record will be visible when:

 

Scope::FieldName = ValueListItems ( Get ( FileName); "ValueListName")

 

Is there a different way I can compare this field to all the entries under the value list and see if it matches any of them?

 

Thanks!

[comment]

Try =

not IsEmpty ( FilterValues ( Scope::FieldName ; ValueListItems ( Get (FileName); "ValueListName" ) ) )

[mdavis6537]

This works perfectly, thank you! I dont see how to mark you as the answer but I upvoted at least