Passing an argument through Expression.Evaluate

[rpiboy_1]

Building from this thread: Solved: Pass Text String as Function Name - Microsoft Fabric Community

And having also reviewed Chris Webb's blog post as noted in the same thread.

I need to pass an arguement to the function, from a colum. So my set-up looks like this:

Geo	DataType
US	projects
US	users
CA	projects
CA	users

so now I need to write an expression that looks like this:

    #"ExecuteFunction" = Table.AddColumn( 
        Source,
        "AdminData",
        each Expression.Evaluate(
            "FnAdminQuery"&[Geo]&"("&[DataType]&")",
            #shared
        )

The trouble of course is the inner referecnce to the 'DataType' column. I was able to create a combined Record that included the List of [DataType] with #shared (per CW's blog post) but of course I get an error because I'm attempting to pass a List to the Function Arguement that is looking for a Text String. I'm not sure how to pass the current row state to the inner function to get the correct index from the List, or perhaps a different approach?

CW's blog post only deals with static variables that are constant for the entire expression. If Reza Rad's blog post (referenced by CW) has more information, the current link returns a 500 error.

[slorin · Accepted solution]

Hi, 

use Function.Invoke

Function.Invoke(Expression.Evaluate("FnAdminQuery"&[Geo], #shared),{[DataType]})

 Stéphane

[rpiboy_1]

Thanks so much! That was much easier than I was expecting!

[rpiboy_1]

@slorin perhaps you can shed some further light on my challenge. TY!