list all tables' names dynamically

[umtkyn]

hi,

Is there a way to create a list of all tables' names dynamically in an excel file with powerquery ?

Thanks,

[umtkyn]

thank you, i was actually trying to append all the tables in it and i found a solution... for future reference i write it also here...

Source = Excel.Workbook(File.Contents("C:\Users\777\filename.xlsx"), null, true),
#"Filtered Rows" = Table.SelectRows(Source, each ([Kind] = "Table")),
CombineTable= Table.Combine(#"Filtered Rows"[Data])

[AntrikshSharma · Accepted solution]

@umtkyn You can use the path of the current file and then filter for Tables.

let
    Source = Excel.Workbook ( File.Contents ( "C:\Users\antsharma\Downloads\1.xlsx" ) ),
    TableNames = Table.SelectRows ( Source, each [Kind] = "Table" )[[Name]]
in
    TableNames

[umtkyn]

how do you manage if you need to do it in the same file ?