Parameter Query in Power Query - component of website

[albertan]

I have a power query table that is consuming a specific table from the website. However I need to make it dynamic so that it can refer to a cell in my excel so that the table source could be changed otherwise I have to go to Advanced Editor and manually change the table number. Is it possible to make this table number dynamic (i.e. change the table number F111 to F112 table for example that I can change in excel cell location) when I have the this in Advanced Editor:

Source = Web.Page (Web.Contents ("https://XXXX.com/F111"))

 

[johnny51981]

This may be somewhat similar to the post, see if the reply I provided there will be of assistance.

PowerQuery - Dynamic Path

Hi , I have been able to create my first dynamic path linked to a folder. Still working to understand the logic involved in the the creation process. My dynamic path seems to work but only if I update the name of the file in the advanced editor but I have seen people simply dragging and drop...

www.mrexcel.com

 

[albertan]

In my case, it's a different situation, I get the data from an external website. And the structure of the website is that the last 4 digits refer to the table name. I have a list of those tables which I'd like to be dynamically changing the source data each time I change the source table (which is a portion of the https' website). Thanks

 

[jdellasala]

What johnny's solution indicates is that you can bring a Named Range into Power Query:

let
    Source = Excel.CurrentWorkbook(){[Name="WebTarget"]}[Content],
    Column1 = Source{0}[Column1]
in
    Column1

That is brought in as a single cell table. The Column1 step above is [Right Click] Drill Down of that cell.
In the code above, WebTarget is a single cell named range which is a Data Validation list.

Book1
	C
1	parameter-query-in-power-query-component-of-website.1223423/
2	partially-syndicated-outbound-splitting-one-table-into-two-tables-to-use-calculation-formula-for-each-table.1223477/
3	my-whole-data-is-messed-up-when-updating-power-query.1223059/
4
5	parameter-query-in-power-query-component-of-website.1223423/
Sheet2

Cell Formulas
Range	Formula
C1:C3	C1	=TEXTAFTER(A1,"/",5)

Cells with Data Validation
Cell	Allow	Criteria
C5	List	=$C$1:$C$3

Point that to the list of 4 digits you have, and incorporate it into your Web query.

let
    Source = Web.Page(Web.Contents("https://www.mrexcel.com/board/threads/" & WebTarget)),
    Data0 = Source{0}[Data]
in
    Data0

You can hard code the base URL (https://www.mrexcel.com/board/threads/) using a LET statement in the query, or even bring it in as a Named Range from a Worksheet.