-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
list.containsany
-
D
Expression.Error: We cannot apply field access to the type Text
I am trying to check if there are any exact matches between [Email Domain] (contains a single domain) and [All Matches] (contains a bunch of domain). However, it keeps returning the error below Initial State \ Code = Table.TransformColumns(#"Grouped Rows", {"All Matches", each let...- donkey shrek
- Thread
- field access keyvalue list.contains list.containsany list.findtext powerquery
- Replies: 0
- Forum: Power Tools
-
D
Text.Contains with List Parameter
I want to check if each column value contains a substring of each value in a list, and output "FOUND" if true. Current Code: = Table.AddColumn(#"Source", "TEST", each if Text.Contains([Email Domain], RandomList) = true then "Found" else "Invalid")- donkey shrek
- Thread
- list list.contains list.containsany power query text.contains
- Replies: 2
- Forum: Power Tools
-
D
List.ContainsAny not working in List.Accumulate
If I use Text.Contains to have 1 filter only, it works fine (e.g. only those containing "@"). However, I want to combine the filters into 1 query so there won't be so many steps. Therefore, I'm using List.ContainsAny instead. I think it's because PQ cannot pick up List.Accumulate's "current" if...- donkey shrek
- Thread
- filter list list.accumulate list.containsany powerquery
- Replies: 8
- Forum: Power Tools
