Column of type "Function.Type" in Enter Data functionality

[Taurus]

  Hi all!

  I'm about to create custom table using Enter Data with this structure:

RestaurantName  | External_ID  |  API_FUNC_PROCESS

  First two fields are textual, but the last one must be of type function which I'm going to use in M Function.Invoke call.

  I can add custom column like this code:

= Table.AddColumn(Source, "API_FUNC_PROCESS", each #"Execute External API CALL For Restaurant XXXX", Function.Type)

But the code adds the same function for all rows in my custom entered table.

The question is: How to manually enter value of type function (or Function.Type) OR how to manually enter, for example, function name and at the next step transform it to Function.Type type?

[v-juanli-msft]

Hi @Taurus 

Would you like the new added column to be dynamic with different input?

If so, you could try parameter, references are as below:

Use parameter in Power BI

Create dynamic parameter

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Taurus]

No, it is bad idea, I need to use different functions to process different corporation/departments using api call in Web.Contents, othewise PBI Service will not allow to schedule normally if url is being dymanic.

[Taurus]

I know how to execute function by its name using Expression.Evaluate:

Expression.Evaluate("Function.Invoke(" & func_process_name & ", {""corporation/departments""})", #shared)

but I want to implement this in a more elegant way.