Get sheet in the first order(most left sheet) no matthe what its name is

[Anonymous]

Hi,

What M code can we get sheet in the first order(most left sheet) no matthe what its name is?

Sheet name is dynamic so I shouldn't type in the code. 

e.g. for this snapshot, it will be TOSS Serivce PO_Master cuz it is the most left(first)

[Anonymous]

I've tested as below and it seems it will stack in initial order unless put other filter to affect. 

Then I can just take first row in Query. 

If it is not correct pls guide me. 

[shafiz_p · Accepted solution]

Hi @Anonymous  Try this way:

let
    Source = Excel.Workbook(File.Contents("YourFilePath.xlsx"), null, true),
    FirstSheet = Source{0}[Data]
in
    FirstSheet

Just replace "YourFilePath.xlsx" with the path to your Excel file. This will dynamically get the data from the first sheet, no matter what its name is.

Also, your mentioned method would work.

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz