How to show those feilds in lookup which is "isactive=yes" in list,

Question

Greetings,

I have created lookup column in one of my custom list, its fine

Problem: in look up column , I just want to show those fields which status is "isactive=yes".

Note: "isactive" is a bool type column in its list name"status list" , like below.

I mean in my list( list name "status" there are 2 fields status and isacivte

and this list is being used as a lookup in other list to show status in dropdown.

below are images for reference

Answer 1

Hi @Mohammad Qasim ,

To make a filtered look up column, please refer to the following steps:
1.Create a calculated column in source “Status” list using the formula: =IF(IsActive=FALSE,””,Status) . The calculated field will be empty if IsActive field equals to No, otherwise it will display the value of Status field.

2.Configure the lookup column in another list to use the value from the calculated column instead of Status column.

Test results in my environment: