May I know the reason why you need to use in instead of StartsWith? You can use the in function to find a string in a data source, such as a collection or an imported table. The in operator identifies matches regardless of case. The StartsWith function tests whether one text string begins with another. So did you mean that your search string would not be one text string begins with another?
Community Support Team _ Mona Li If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.