I have the following formula
Output=Table.AddColumn(TextToChange,"Changed Text", each ReplacementFunction([List])) //[List]=Column name to change
If I try to replace list by a variable and integrate this row to a function. But even if I change to
Output=Table.AddColumn(TextToChange,"Changed Text", each ReplacementFunction(TextToChange[List])) //[List]=Column name to change
I receive an error because type 'list' can't be converted to 'text'.
So actually I am not able to handover this with a function because I only know how to handover lists and tables.
Do you have any idea how I can solve this issue?
ReplacementFunction([List]) function need a parameter of type text, but TextToChange[List] return type of list.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!