cancel
Showing results for 
Search instead for 
Did you mean: 

Improve IN operator: allow to filter a list based on a multiple objects column (multiple selection combo-box)

It would be great if it were possible to use Filter like this:

 

 

UpdateContext({_UserObjectVar: User() })
Filter(MyList, _UserObjectVar in AppointedUsersColumn)

 

 

Where:

- MyList is a collection (a Sharepoint list in my case)

- _UserObjectVar: stores a user object

- AppointedUsersColumn is a column in MyList, of "user or group" type, contaning multiple user objects per record. Such a column is usually employed by ComboBoxes with multiple selection allowed.

 

 

As an alternative, it would be great if the IN operator was actually delegable.

For example:

 

 

Filter(MyList, "this string" in TextListStringsCol)

 

 

 Where in TextListOfStringsCol records there are simply concatenated strings such as

 

 

"that string,this string,yet another string"

 

 

The In operator is supposed to be able to find a substring ("this string") in a string ("that string,this string,yet another string"), and is supposed to be delegable. But isn't. Please fix it.

 

Thank you

 

Thank you

Status: New