My users can save their favorite movies to the User data type with the field “Top Movies” which is a list. I want a button to be able to search for all users with one or more of the same favorite movies as them, and then navigate to one of those users randomly. I want the search for users to return all users who have at least one exact match in the current users Top Movies, which again, is type list. The setup I have below only works when one of the lists only has one entry so i need something beefier. I have not worked with intersect or filtering much, maybe one of those will help with this feature. Any ideas appreciated.
Also, the movie titles are pulled and saved via API, so different spelling isn’t an issue, every movie is spelled the same way. Thanks!