How to use list.contains from another query

Hi cheryl-lee33 

The problem is once you use the List.Contains, you are limited in scope as to what it can see. You need to assign your values you want compared to a variable first. So something like this, as viewed in the Advanced Editor:

    #"Add Column" = 
        Table.AddColumn(
            #"Changed Type",
            "New Column",
            each let 
                varFieldValue = [Local authorities]
            in
                List.Contains(
                    Table.Column(#"Source 2", "local authority - Group"),
                    varFieldValue
                )
        )

This will return a true/false column, which you can then filter.