Forum Discussion
RappJ
4 years agoHelper I
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...
- 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.
RappJ
4 years agoHelper I
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.