Forum Discussion
William Hardwick
Oct 14, 2018Iron Contributor
Filter calculated Lookup field from my contact list
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
- Alan MarshallSteel Contributor
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
- William HardwickIron ContributorWhat did people do before power apps?
Is there any documentation on how to do this?