How to pass cell value as the Query value for a query utilizing Power Query
Good Morning, 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