This article provides formulas for Text.ContainsAny and Text.ContainsAll functions as these are not provided by Power Query Language M.