I am trying to setup a form to pull from a SharePoint list of "Active" services for particular "Customers". I am able to filter based on Status = Active, but the Customers field in my Services list is a mutli select field and I cannot figure out how to filter based on that.
Examples:
This formula works for me to filter on Services whose Status = Active:
Filter([@Services], Status.Value = "Active").Title
But this doesn't work and on Customers.Value tells me I "Cannot use table values in this context"
Filter([@Services], Customers.Value in ["Corporate"]).Title
What am I doing wrong?
