cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Rob_CTL
Level: Powered On

Using SharePoint list lookup column as source for combobox to filter gallery?

Hi,

 

Hope someone can help me with this as I can't seem to get the filtering syntax right when using a SharePoint lookup column.

 

Configuration:

 

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

 

powerapp-filter.jpg

 

powerapp-filter2.jpg

 

If someone can point me in the direction of the right syntax that would be great!


Thanks

Rob

1 REPLY 1
AndySid
Level 8

Re: Using SharePoint list lookup column as source for combobox to filter gallery?