Forum Discussion
Solved
Is it possible to create a query from text?
I have a scenario where I need to generate a dynamic query and wondered if it is possible to do so by "creating" a query from text. For example, if I had a text field that contained the following...
Yes. You can use Expression.Evaluate("M expression") for that.
Expression.Evaluate - PowerQuery M | Microsoft Docs
Pat
Looks like you are missing the let and in parts of your query inside your Expression.Evaluate.
Pat
That did the trick! It's a bummer the applied steps aren't listed using this method, but the method is great just the same. Appreciate it!
