How to return a specific record from a list using power query?

[kroeterix]

Hello,

I have created a list with 3 types of fruits {"apple", "banane", "blackberry"}. I have the function List.First to return the first record (apple) and the funktio List.Last to return the last record ("blackberry"). But how can I return the second, or thrid or Nth record of a list.

Thank you very much in advance!

Sammy

[Greg_Deckler · Accepted solution]

Hey Sammy, you want to review this reference:

https://msdn.microsoft.com/en-us/library/mt299038.aspx

Specifically, the answer to your question is:

ListName{1}

Here is test M code:

let
    MyList = {"apple", "banana", "blackberry"},
    Output = MyList{1}
in
    Output

Lists are essentially zero-based arrays.