Power Platform Community Forum Thread Details

How to filter a SharePoint list based on a lookup column and a choice columns in Power Apps?

The Scenario is Two Sharepoint List and one Document Library
SharePoint List EmployeeList
EmployeeCatagory - Choice Column
Values-"Fresher","Experienced"

SharePoint List- ABCHRDropDownlist
EmployeeCatagory-Choice Column
Values-"Fresher","Experienced"

SharePoint List - ABCHRDropDownlist
DocumentType - Lookup Column
Values in the column- "Aadhar","PAN","DL"

How to check if
EmployeeList>EmployeeCatagory>value Experienced = ABCHRDropDownlist>EmployeeCatagory>Experienced
filter sharepoint Experienced=Experienced and filter ABCHRDropDownlist
required DocumentType needs to filter from ABCHRDropDownlist

I Tried
The above value is stored in Power App- Home screen - Edit Form SharePointForm1>DataCardValue10.Selected.Value And another screen galMetadata_1 in EmployeeCatValue.Text

I tried this below Formula But i have No Luck , the record or value is not visible.How to fix this?
Filter(
ABCHRDropDownlist,
EmployeeCatagory.Value = EmployeeCatValue.Text
).DocumentType

Quick Links

Leaderboard > Power Apps - Power Query