You’re offline. This is a read only version of the page.
Announcements
57
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
Hi @AKB2021 ,
I did a demo for you.
1\ This is my list .
2\ Add a dropdown control 'userList.NAME' and set its Items property to:
Share
Report
All responses (
Answers (
userList.NAME
3\ Add a gallery control and set its Items property to:
Filter(ForAll(Filter(userList,NAME<>Dropdown1.Selected.NAME) As A,If(CountRows(Filter(ForAll(LookUp(userList,NAME=Dropdown1.Selected.NAME).Languages As B,If(B.Value in A.Languages.Value,B)),!IsBlank(Value)))>0,A)),!IsBlank(NAME))
4\ The result is as follows:
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
