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 query.

Any thoughts?
Thanks,
Jason

 

 Query:

let
    Source = OData.Feed("https://******************", null, [Implementation="2.0"]),
    BhaEquipmentUses_table = Source{[Name="BhaEquipmentUses",Signature="table"]}[Data],
 #"Filtered Rows" = Table.SelectRows(BhaEquipmentUses_table, each (#"Target Tool List derived from Target Tools"))

in
    #"Filtered Rows"

Error recieved:
Expression.Error: We cannot convert the value "[MaterialNumber] = "..." to type Logical.
Details:
Value=[MaterialNumber] = "111111111" or [MaterialNumber] = "2222222222" or [MaterialNumber] = "3333333" Type=[Type]

Need Help
  • RappJ's avatar
    RappJ
    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.

1 Reply

  • RappJ's avatar
    RappJ
    Helper I
    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.