donkey shrek
New Member
- Joined
- Nov 15, 2022
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
I want to check if each column value contains a substring of each value in a list, and output "FOUND" if true.
Current Code:
Current Code:
Power Query:
= Table.AddColumn(#"Source", "TEST", each if Text.Contains([Email Domain], RandomList) = true then "Found" else "Invalid")