Hope someone can help me with this as I can't seem to get the filtering syntax right when using a SharePoint lookup column.
SharePoint list called "Customers" with a single text column called "Customer" (renamed Title column)
SharePoint list called "Sites" that has a lookup column called "Customer" that uses the "Customers" list for it's source
PowerApp screem with a gallery connected to the "Sites" list. A Combobox that is also using the "Sites" list as it's source. The combo box is configured to use the "Customer" lookup column as it's primary text.
I have applied the following filter to the "Items" elemnet on the gallery:
Filter(Sites, Customer in ComboBox4.SelectedItems.Customer)
This throws errors relating to the ID column missing, this I can understand because of the way Lookup columns are repersented in SharePoint. See below for errors
If someone can point me in the direction of the right syntax that would be great!