Filter calculated Lookup field from my contact list

Iron Contributor

Here is my scenario,

I want to relate my Tasks in my TASK LIST to my "Active" clients found in my CONTACT LIST.

I have a choice field in my CONTACTS LIST called "Client Status" with two options (Active & Not Active).

I also have a "FullName" Calculated Lookup field, that combines (LastName, First Name).

 

Is there a way to only show active clients in the drop-down lookup field.

I was thinking of creating another lookup field or editing or creating another lookup field.

 

Thanks in advance for all your input. 

 

2 Replies

You will need to customise the form with PowerApps and replace the data source in the drop down list it creates with a Filter in the Active field

What did people do before power apps?
Is there any documentation on how to do this?