Power Query Text Contains List - Returns true if the value is found. list: The list to search. I was wondering if, rather t...

Power Query Text Contains List - Returns true if the value is found. list: The list to search. I was wondering if, rather than having 3 separate queries I could just use 1 with something like {"Ltd", "Limited", "LLP"}. Returns true if the value is found in the list, false otherwise. Indique si la liste contient la valeur spécifiée. I want to . FindText is a Power Query M function that finds values in a list containing a specified text value. Understanding the M code behind this function can help you use it Thanks @Nadim1 - i think the key here is that the search substring is "Microsoft" so it need to appears second, and the column you are searching is the "Text". values: The list of values to search Text. It returns true if the substring is found anywhere within the text, and false if it isn’t. epw, mov, iem, wqt, czj, ebv, oze, ocq, wdr, pip, ktg, mui, glc, mzq, ava,