Dynamically combine multiple tables into one table

[torman119]

I need to combine several tables from Azure storage dynamically into one table. I have for instance the following dynamically created tables:

userstable564736

userstable595743

userstable434534

othertable434342

othertable342856

I want to combine all tables which start with "userstable" into a single table. All these user tables have same schema. I don't know the full names of them upfront.

I tried this:

let
   Source = AzureStorage.Tables("https://storageaccount.table.core.windows.net"),
   userstables = List.Select(Source, Text.StartsWith([Name],"userstable")),
   combined = Table.Combine(userstables)
in
   combined

But I get error message

Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?

Can somebody help?

[torman119 · Accepted solution]

Following solution works

let
   Source = AzureStorage.Tables("https://storageaccount.table.core.windows.net"),
   usertables = Table.SelectRows(Source, each Text.StartsWith([Name], "userstable")),
   combined= Table.Combine(usertables[Data])
in
   combined