List with all the names in a group

[Mic1979]

Hello,

I have my tables in group as in the picture:

What I am doing now it to get a list of all the table names in the group in this way:

let
Source = Excel.Workbook(Web.Contents("https://emerson.sharepoint.com/sites/1058573_Car-washManifold/Shared%20Documents/10_Project_Manageme..."), null, true),
TableNames = Table.SelectRows ( Source, each [Kind] = "Table" )[[Name]],
#"Filtered Rows" = Table.SelectRows(TableNames, each ([Name] = "Box" or [Name] = "Clip" or [Name] = "Coil" or [Name] = "CoreTube_SubAssy" or [Name] = "Core_SubAssy" or [Name] = "Cover" or [Name] = "IM_Sheet" or [Name] = "ORing1" or [Name] = "PlasticBody_SubAssy" or [Name] = "Screw1" or [Name] = "Spring1" or [Name] = "Terminal_Protection"))
in
#"Filtered Rows"

Is it possible to make this list dinamically, with all the tables included in the group Components BOM?

Thanks.

[sanalytics · Accepted solution]

@Mic1979 
Not as a list.. But you can get the all the Table name in one place by using #shared keyowrd..
Below is the code

let
    Source = #shared,
    #"Converted to Table" = Record.ToTable(Source),
    #"Filtered Rows" = Table.SelectRows(#"Converted to Table", each Value.Is([Value],Table.Type))
in
    #"Filtered Rows"

screenshot

from here, you will have to use your brain and logic how to provide the group name of each table.

Hope it helps

Regards

sanalytics

[Mic1979]

Hello @sanalytics 

in fact I designed properly the source table, and then I applied a proper filter.

TableNames = Table.SelectRows ( Source, each ([Kind] = "Table" )),
#"Filtered Rows" = Table.SelectRows(TableNames, each Text.Contains([Name], "Breakdown")),