donkey shrek
New Member
- Joined
- Nov 15, 2022
- Messages
- 26
- Office Version
- 365
- Platform
- Windows
I am confused why my Custom Column returns a Function instead of lists?
Output:
I have also tried assigning the list parameter in List.Select to a variable first but the output is the same
Output:
Power Query:
= Table.AddColumn(#"Grouped Rows", "Test", each if List.FindText(Text.Split([All Matches], ","), [Email Domain]) <> false then each let EmailDomainVar = [Email Domain] in List.Select(Text.Split([All Matches], ","), each _ = EmailDomainVar) else "H")
I have also tried assigning the list parameter in List.Select to a variable first but the output is the same
Last edited: