Imke Feldmann has an interesting solution to a text search problem in Power Query:
In the native function, you have to pass in a record with search term and column name. So if you search for “blue” in column “Description”, your formula would look like so:
Table.Contains( YourTableName, [Description = "blue"] )But that’s not what I want in this case. I want the formula to search through all columns within the table for the occurrence of “blue”.
Read on to see how to do this.