Forum Discussion

RappJ's avatar
RappJ
Helper I
4 years ago
Solved

run OData query filtered by a Text.Combine string

Good day all, I am attempting to create a list with a set of master Material Numbers to filter my query by. The text string looks correct however I get erros when attempting to reference it in the q...
  • RappJ's avatar
    4 years ago

    Solved, I was making it to complicated. 
    #"Filtered Rows" = Table.SelectRows(BhaEquipmentUses_table, each List.Contains(#"Target Tools Query List",[MaterialNumber]))
    Just needed a list of numbers, no extra text.