SOLVED

How to filter lookup column based on another column from using specific criteria?

Occasional Contributor

Hello,

I have the following lists

  • List - 1 : EmployeeList 
    • EmployeeName - Single line text column
    • Active- Choice column : True or false

  • List - 2 : EmployeeWorkLoad
    • EmployeeName - lookup column from Employee List

 

Is it possible to filter out items displayed in the lookup column based on (Active= True) so that, while creating new entry in EmployeeWorkLoad List it won't show deactivated employees in look-up column.

3 Replies

@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:

  1. PowerApps filter on Lookup column from SharePoint 
  2. 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.

best response confirmed by New_learner (Occasional Contributor)
Solution
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

@SvenSieverding,

 

I have done like this only.

=IF(Active="true",Name,"")

 And it worked as expected.
Thank you for your response.