Passing parameters to Transform Power query connector - How to?

[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?  

[v-xiaochen-msft · Accepted solution]

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-Powe...

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

Best Regards,

Wearsky

[pbapuji]

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