Unanswered

Passing parameters to Transform Power query connector - How to?

(0) Share

Report

Posted on by pbapuji

Hi there, my flow can receive parameters send by another application ( in this case Visual cron) using HTTP request received trigger which i want to pass to the subsequent action "transform power query connector" and use in it.. not able as i tried various options such as triggerBody()? syntax, & <parameter_name> & syntax. In the Power Query connector, How should i receive the values as parameters? How_to pass_parameters_power_query_action_1.png

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @pbapuji ,

Currently, this behavior is not support . The idea is already on the forum and you could vote for it.

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Add-ability-to-load-dynamic-content-in-Power-Query/idi-p/211409

As a workaround , you could do a filter query action after runing a power query in flow.

Best Regards,

Wearsky

Was this reply helpful? Yes No
pbapuji 4 on at

Like (0)

Report

Thank you very much for the reply !! I really believe this type of functionality should be in-built from start ..

Was this reply helpful? Yes No
brazecf 2 on at

Like (0)

Report

You can accomplish this in the New Designer. Using the Old Designer, create your query with the parameters you need using the Power Query editor. Once complete, save and toggle to the New Designer view. In the New Designer, you can only edit the Power Query code, there is no power query editor. Find the parameter value in your code, and replace it with the variable or function you want from the flow. In the example below, my parameter is called "FilterYear" in Power Query, and the variable I'm using in my flow is called "mYear".

Was this reply helpful? Yes No