So I have three tables: Master, Products and Vendors.
Master table has a column named "Product" which looks up the Products table
Products table has a column named "Vendor" which looks up the Vendors table
Vendors table has column named "Vendor Name"
I have a combo box in my application whose items come from the "Vendor Name" column in the Vendor Table. Whenever a new item is selected it's put into a collection called "selectedVendors_collection".
I also have a gallery whose items are dependent on whatever is in the combo box.
I'm trying to use the following formula to filter my gallery items based on whatever items are present in the combo box.
Filter(
'Master',
(IsEmpty(selectedVendors_collection) || Product.Vendor.'Vendor Name' in selectedVendor_collection.Result)
)
When adding to my combo box all cells within the gallery disappear which leads me to believe that the second half of the "or" statement is the one being evaluated to true but somehow there is nothing shown. I've tried a few different lookup() functions to see if that would work but haven't had any luck yet. Why would there be no cells shown in the gallery and how do I correctly reference the "Vendor Name" column?
