Forum Discussion
set default value of text parameter using a query
With a binary parameter type, you can set the default value by way of a query. With a text parameter type, there is no default value option. I have a text parameter in a query that I've made int...
Thank you for the response, I may have not understood but I think this is a slightly different scenario with SQL queries.
I have a text parameter, the query option here is a Power Query, and can certainly be used to provide a list of options, but what I want is to set the default value like with the Binary Type. The below parameter uses a query to pull the latest doc in a SharePoint library for example. Why can't I have a parameter that uses the latest filename?
I need it to be a parameter because while I use the default value when testing, when created as a function it will get passed a value.