Passing Dynamic content to Power Query?

[otravers]

I've read the little content I could find on Flow's PQO, but couldn't confirm whether "Transform data using Power Query" is supposed to be able to receive dynamic content output from a previous step, i.e. turn a value from earlier in my flow into a variable I could inject in the M code / SQL query. Help appreciated!

[v-yamao-msft]

Hi @otravers,

Per my certain test and research, I am afraid that it might be not possible to pass dynamic content to Power Query, it is not supported yet.

If you need this feature, please feel free submit a request on Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

I will suggest other customers who have the same request vote your idea as well.

Best regards,

Mabel

[otravers]

Thanks Mabel. Here is the idea:

https://powerusers.microsoft.com/t5/Flow-Ideas/Add-ability-to-load-dynamic-content-in-Power-Query/id...

[v-yamao-msft · Accepted solution]

Hi @otravers,

Thanks for updating.

Please feel free reach us if you have any questions related to Microsoft Flow, we are always ready to help.

Best regards,

Mabel