how to create an user input to edit web address

[Anonymous]

I have a query that is based on a web address.

the address changes based on the date

is there a way of inputting the date required?

which then can be 'sculptured' to load the correct web page?

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Based on my test, you could refer to below formula in Advanced language in query editor:

(para as date) as table =>
let
    Source = Web.Page(Web.Contents("https://www.accuweather.com/en/sg/singapore/300597/december-weather/300597?monyr="&para)),
    Data0 = Source{0}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Sunday", type text}, {"Monday", type text}, {"Tuesday", type text}, {"Wednesday", type text}, {"Thursday", type text}, {"Friday", type text}, {"Saturday", type text}})
in
    #"Changed Type"

See the highliaght code, after you have applied it, you could choose the data to invoke the function:

In this example, I need to ues the text due to I have not found the situable web source:

Result:

Regards,

Daniel He