Parameter change(not refresh)

[ExcelStarter]

Changing parameters and then loading does not automatically refresh them.

 

[horseyride]

View attachment sample.xlsx

Create a named range Table3 with Column header Parameter and the actual parameter below that; reference the value in Powerquery using Excel.CurrentWorkbook(){[Name="Table3"]}[Content]{0}[Parameter]

let Source = Excel.CurrentWorkbook(){[Name="List"]}[Content],
ChangeType = Table.TransformColumnTypes(Source,{{"list", type text}}),
Parameter = Excel.CurrentWorkbook(){[Name="Table3"]}[Content]{0}[Parameter],
FilteredRows = Table.SelectRows(ChangeType, each (
[list] = Parameter))
in FilteredRows

 

[ExcelStarter]

Thank you for your reply.

Could you tell me why it is not refreshing?