Need different sheet names to be called using query and link in these places in Power Query Editor

[tjayapal]

Need different sheet names to be called using query and link in these places in Power Query Advanced Editor. I'm using another table to get the sheet name and call that as a query, but not sure how to link in these place, whatever I type, it is showing as error. Need help, thank you in advance for spending time on this. Much appreciated.

Getting this error

[Noroozi]

Hi tjayapal,
You can simply delete the "Item part" in your query. I highlited it in the screen shot.
NB: be careful if you have more than one sheet in your source, this trick may not work properly.

[danextian]

M is a case-sensitive language. Should be List.Contains not list.contains thus you're getting an error that the latter wasn't recognized.

[danextian]

Hi @tjayapal ,
You can actually connect to multiple sheets in an Excel file easily. Remove all steps after Source in Applied Steps. You will see the list of worksheets, named range, etc in the preview. Filter to Sheet under Kind column and just select the worksheets you need.

[tjayapal]

Hey. Thanks for responding spontaneously. 

I understood your answer, but what I want is that power query editor to act dynamic. In another sheet, I just have only one table where I will fill only one value which is the name of those sheets which I have in my database sheet. So when I change the date in the excel, it should automatically refresh its value, using the sheet which I mentioned instead of manually changing the sheet every time in power query editor. Hope I explaiend clear, if not let know so that I will try to eloborate more.

[danextian]

Here's what I would do

• Create a separate query for the name of sheets and convert it to a list.  Right click the column that contains the name of sheets and then click Drill Down.
• Filter the table that contains your data using  Table.SelectRows(Source, each List.Contains( Sheets, [Item] ) )
• 

   Change Sheets to the actual query name contains a list of sheet names.

[tjayapal]

Hey, I can understand what you are trying to say, but I'm really a starter and not sure how to get the 26-Apr-2022 as value, could you help on the exact situation?? See below for screenshot

Again thank you so much