Oct 14 2018 09:25 AM
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.
Oct 14 2018 04:20 PM
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
Oct 15 2018 01:45 PM