I have a SharePoint List which contains user data like Name, Age, Language spoken, Country, etc. I am using a PowerApps form to input data into this list, where only Language Spoken is multi choice field.
Now I want to filter the list based on a selected user and the languages they speak. For e.g.
| Name | Age | Languages | Country |
| ABC | 25-35 | English,Russian | USA |
| XYZ | 35-45 | German,Spanish | Mexico |
| CDE | 25-25 | Russian,Japanese | USA |
| MNO | 45-55 | English,French | Canada |
So when I select ABC user from a Dropdown in PowerApps, connected gallery should show user names of CDE and MNO as ABC user speaks in English like user MNO and Russian also spoken by user CDE. They can further filter the gallery based on country and age as well.
Filtering Gallery based on Age and Country has been completed using
Filter(userList, uniqueID <> Value(selectedUserID.Text),AgeRange.Value = AgeRange_1.Selected.Value, Country = Country_1.Selected.Value)
Can someone help on how to filter the list based on Languages spoken by selected user?
Thanks,
AK

Report
All responses (
Answers (