Power Platform Community Forum Thread Details

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,

Categories:

Building Power Apps