Pass query/list parameter to function

[elijah2018]

Hi everyone, 

I needed to import data from the web where it was just the ending of the URL that was changed. 

So I read and implemented on how to create a function where I could pass the ending of the URL to the function as a parameter. 

The function had the following structure: 

(DataItem as text) =>
let
source = Csv.Document(Web.Contents("www.mydatabase.com/" & DataItem), [everyting else....]) 

in 
source

 So the problem that I have is that there is a small box below the function description where I can type in a string that is passe to the function, but what I would like is that instead of having to type in a string all the time I want to be able to select DataItem from a specified list parameter och a query parameter. 
But I dont know how to specify to the function that the parameter should be a query or a pre-specified list. 

Thank you in advance for your help 

Best regards 

Elijah

[v-yulgu-msft]

Hi @elijah2018,

You could check the similar examples in below links:

Dynamic connection to Web URL

Passing a parameter to a URL

Regards,

Yuliana Gu

[Stachu]

it's explaind in this article
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/