Lookup dropdown list due to special SP view? (pre filter)

Forms SharePoint 2019
1

Hello everyone,

I'm asking if is it possible to pre-filter my lookup dropdown list already existing?

Let me explain.

I've got a form with lookup dropdown list that I would use(=show) only if answer to special criteria (not all item in this list, right).

So, how could I have a list with, for instance, just all division depending to column "Billing?" with criteria = YES?

Any ideas ?

Thanks a lot in advance,
Also, wish you the best your this year 2025 :smiley: health and "lot of fun if possible" of course.

division list with colum with criteria
division list with colum with criteria1802×837 55.7 KB

2

Hello @lolopixxx,

You can create a static filter for Lookup field with the code:

fd.spRendered(() => {
    fd.field('Lookup').ready(field => {
        field.filter = "ColumnName eq 'Yes'";
        field.refresh();
    });
});

Find code examples for all column types in the documentation: