Forum Discussion
Solved
Invoking custom function from within a query
Hi all, I don't seem to find correct syntax to invoke my custom function from a query. I have this function called xReplace that changes a lot of strings into something else. The function has no ...
Function.Invoke expects a list as second argument.
It should be OK if you put the argument between curly brackets.
let Source = .... my = Function.Invoke(xReplace,{#"Renamed Columns"}) in myOtherwise you might consider not to use Function.Invoke and just call the function directly.
I don't think Function.Invoke has any added value in this case.
MarcelBeug wrote:By the way, for multiple replacements you might consider using List.Accumulate.
I understand this is to change individual characters. I need to change the whole phrases.
In the example I may have used List.Accumulate to replace single characters.
In the video below, you can find more information about List.Accumulate with an explanation on how to change substrings starting at at 3:23.