Forum Discussion
Solved
Power Query Custom Function how to select a list
HI, Is it possible to select a list the same way you can a table when creating a custom function, so starting pont; nested list old / new values; rplace =
{ { "cat", "CAT"}, {"cow", "C...
Check this:
= (myTable as table, column as text)=> Table.TransformColumns(myTable, {{column, each Text.Combine(List.ReplaceMatchingItems(Text.Split(_, " "), {{"cat", "CAT"}, {"dog", "DOG"}}), " ")}})Now you can invoke this function by selecting a table with dropdown list and entering Column Name as text.
OK. I have no clue. I have seen this behaviour, but I never use the UI to call a function anyway....