Good Day,
I am very green to Power Query, so I’m unsure if this is even possible.

Base Goal:
Pass the value from “SELECT_COL” as the UserQuery “let” statement.

Clarifiying Details:
I have 2 datasets

1. SURVEY_PARAMS

2. SOURCE_LKP_FILE

I have successfully been able to filter down the SOURCE_LKP_FILE until I get just the 1 cell value “SELECT_COL”

Code to get to just the query value I want to pass into the UserQuery(I can modify my SOURCE_LKP_FILE and add in or remove anything that’s needed to help make this dynamic) below:

let
Source = SOURCE_LKP_FILE,
#”Filtered rows” = Table.SelectRows(Source, each [TABLE_NAME] = “FOWLER_LKP_TBL”),
#”Choose columns” = Table.SelectColumns(#”Filtered rows”, {“SELECT_COL”}),
#”Drill down” = #”Choose columns”{0}[SELECT_COL]
in
#”Drill down”

I want to take the cell value from above and use it as part/whole of my UserQuery(my user query will just be a series of extract by range)

I’m a heavy pipeline adf worker and I thought I’d be able to do some form of referencing within here like:

let
Source = SURVEY_PARAMS,
#”Inserted text range” = $SELECT_COL
in
#”Inserted text range”

Any help would be GREATLY appreciated

I tried referencing similar to ADF’s style but it didn’t work

let
Source = SURVEY_PARAMS,
#”Inserted text range” = $SELECT_COL
in
#”Inserted text range”