Greeting Expert, I have the power query code below that extract data from my workbooks with sheetname "Weld" Please any help me if I need to add a code that extract data with sheetname "InstalledReport" in the code below and secondly I want the code to include the source path in the list Table.Combine(List.Transform(Folder.Files("C:\Users\06567\Desktop\25 status")[Content], each Table.Combine(Table.SelectRows(Excel.Workbook(_,true), each [Kind] = "Sheet" and Text.Contains([Item], "Weld"))[Data]))) I am using MS office 365 Please any help and thanks in advance, 12Rev79

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Power query code to include Source name

Thread starter 12Rev79
Start date Mar 14, 2025

12Rev79

Board Regular

Mar 14, 2025

Greeting Expert,

I have the power query code below that extract data from my workbooks with sheetname "Weld"
Please any help me if I need to add a code that extract data with sheetname "InstalledReport" in the code below
and secondly I want the code to include the source path in the list

Power Query:

Table.Combine(List.Transform(Folder.Files("C:\Users\06567\Desktop\25 status")[Content], each Table.Combine(Table.SelectRows(Excel.Workbook(_,true), each [Kind] = "Sheet" and Text.Contains([Item], "Weld"))[Data])))