Forum Discussion
Solved
How to filter lookup column based on another column from using specific criteria?
Hello, I have the following lists List - 1 : EmployeeList EmployeeName - Single line text column Active- Choice column : True or false List - 2 : EmployeeWorkLoad EmployeeName - looku...
- You could create a new calculated column in the EmployeeList, that only displays the EmployeeName if the employee is active...And nothing otherwise.
=IF([Active],[EmployeeName],"")
Then change the lookup column EmployeeName the EmployeeWorkLoad list to use that column instead of the EmployeeName column
New_learner This is not possible using SharePoint out of the box list forms.
You have to customize the list forms using Power apps for this. Then you can change the "items" property of lookup column combo-box/dropdown based on active column. Check below links for more information:
- PowerApps filter on Lookup column from SharePoint
- Filter Lookup Dropdown list based on values in another SharePoint list
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.