Filter Datasource before populating Combobox

[MHuddlestone]

Hi,

I have an app I've built that currently pulls a data from an excel file on sharepoint. The user uses a combobox to select the item they want to view. Due to the large data set I want to filter the data before it reaches the combox. 

The connection is called dbCameras, comboc box is called cbModel

currently the combo box items looks like this

cbModel.Items:  dbCameras

I want it to be filtered by the Manufacture field in the data. I was thinking this:

cbModel.Items: Flter(dbCameras, dbCameras.Manufacture = "Sony")

I can't seem to get it to work. Any ideas how I can do this?

[Ashwin7104]

Hi @MHuddlestone ,

When utilising column to filter records, you don't need to prefix it with datasource. Use the following function.

cbModel.Items: Flter(dbCameras, Manufacture = "Sony")