Filtered Lookup

Forms SharePoint Online
1

I feel that this should be a simple thing to do, so I might be missing something obvious.

I have a Plumsail SharePoint Form that contains a Lookup control. The data source for the Lookup control is a list located in another site (we’ll call this other list ‘Categories’). The Categories list contains two columns, one called ‘Category Type’ (single row of text data type) and the other column called ‘Visible’ (Yes/No data type). I want the Lookup control in my form to only show the items in the ‘Category Type’ where ‘Visible’ is set to Yes.

I’ve looked at the ‘Filter’ section but this doesn’t appear to be applicable as it’s more for cascading dropboxes.

Any help to be pointed in the right direction would be great! :blush:

2

Hello @aocallaghan ,

this could help you :slight_smile:

1 Like
3

Thank you. After some fiddling around I got it working. Used the following in the fd.spRendered function:

fd.control('CategoryTypeControl').ready(control => {
    control.filter = "Visible eq 1";
    control.refresh();
});
1 Like