I was wondering if there was a way to Filter out a Lookup Column Drop Down. In my example I could create a spicific view to pull from. Or I could say the values I want to exclude. For Example I have a list of cars that I want to refrence but I only want Active and InProccess Cars.
Thank you
Jennifer
Dear Jennifer,
Unfortunately, right now this is quite complicated. It can probably be done using CAML requests, but this is difficult. You’ll need to send a request to the other list to return only items that match the criteria, then only leave these options in the Lookup. Let us know if it’s a crucial feature for you, we can probably look deeper into it.
In the future, we hope to include support for Cross-site Lookup(currently not supported) in the Modern Forms which will include all the described features.