power query if text contains multiple values. power query if text contains multiple values. Posted on 17 febrero, 2022; By . Search (Text Contain) multiple values - Excelguru Power Query - Merging based on if text contains. power query if text contains multiple values power query if text contains multiple values Erkennt, ob text den Wert substring enthält. Text.Contains It will do the merge. The equivalent of the IN function in Power Query uses List.Contains: The function evaluates whether the list contains the value in the column Package. If the value appears, the expression returns true. This example only uses two values in its list. Posted by By triple b forwarders carson ca February 17, … Conditional Merge in Power Query - ehansalytics This function doesn't support wildcards or regular expressions. If you have a list named source in Power Query with 10 items, you can access 5th item of the list with this syntax. power query if text contains multiple values. Here mail1,mail2 is string variable and it contains multiple approvers mail ID. Text.Contains - PowerQuery M | Microsoft Docs