Forum Discussion

Mederic's avatar
Mederic
Post Patron
3 years ago

Add Invoke Custum Function

Hello, I would like to create a Invoke Custum function and then add it in a list/table. I was thinking of a code that would look like the image attached but I don't know how to solve it and also it...
Need Help
Mederic's avatar
Mederic
Post Patron
3 years ago

Hello,

I tested another way with slorin idea using Expression.Evaluate
This works for a single value.
I don't know how to create a function and then apply it to a list
Not sure if this is possible.

Thanks in advance

Best regards

 

let
    TextParam = text,  //Excel.CurrentWorkbook(){[Name="Texte"]}[Content]{0}[Texte]
    Fct = Text.Select,
    ListParam = Expression.Evaluate(Argument),  //Excel.CurrentWorkbook(){[Name="Argument"]}[Content]{0}[Argument],
    Expression = Expression.Evaluate(Fct(TextParam, ListParam))

in
    Expression