Hi,

i start with power qquery

i create a query for import an external excel file and i try

to filter based in a range named ptfslist

this not work. i see in ptf2 the list of values but not work

tks in advance for help

let
    FilePath = Excel.CurrentWorkbook(){[Name="FilePath"]}[Content]{0}[Column1],
    FileName = Excel.CurrentWorkbook(){[Name="FileName"]}[Content]{0}[Column1],
    ptfslist = Excel.CurrentWorkbook(){[Name="ptfslist"]}[Content],
    ptf2=Table.SelectRows(ptfslist, each ([Column1] <> null)),

    Source = Excel.Workbook(File.Contents(FilePath & FileName), null, true),
    CreditsDetailsSwiss_Sheet = Source{[Item="CreditsDetailsSwiss",Kind="Sheet"]}[Data],
    #"Filtered Rows" = Table.SelectRows(CreditsDetailsSwiss_Sheet, each ([Column1] = ptf2[Column1]))
in
    #"Filtered Rows"