define variable

[Valentin]

I have the following code,

let
Source =Web.Page(Web.Contents("https://www.euro-millions.com/results/05-02-2016")),



and for the last part "02-05-2016" I want to declare a variable,
is this possible with power query and if so how I declare that variable?

 

[mole999]

just as example you could

Dim LottoDate

LotoDate = sheets("yoursheetname").Range("A1") ' you'll have to get the right date format at some stage

Then

Source =Web.Page(Web.Contents("https://www.euro-millions.com/results/" & LotoDate & """")), need to get the speech marks right

How thats done in Power Query I'm not sure

 

[Valentin]

Not working that way!

 

[mole999]

I didn't expect it to work perfectly, just to give you a position to start from, it will need adapting to what you have already, none of which has been shared to even start to work from

 

[ImkeF]

If you give the cell where your date sits the name "Variable", the following code will deliver the content:

let
Source = Excel.CurrentWorkbook(){[Name="Variable"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type text}}),
Repl = Table.ReplaceValue(#"Changed Type1",".","-",Replacer.ReplaceText,{"Column1"}),
#"Added Custom" = Table.AddColumn(Repl, "Custom", each Web.Page(Web.Contents("https://www.euro-millions.com/results/"&[Column1])))
in
#"Added Custom"

 

[Valentin]

That's it Thanks

 

[anvg]

Hi
As a variant

    dateInCell = Excel.CurrentWorkbook(){[Name="Variable"]}[Content]{0}[Column1],
    queryDate = DateTime.ToText(dateInCell, "dd-MM-yyyy")
    source = Web.Page(Web.Contents("https://www.euro-millions.com/results/"&queryDate))

Regards,

 

[Valentin]

Hi
Thanks for the variant.

Regards,