How to return a specific record from a list using M?

[kroeterix]

Hello,

lets say I have a list with three records {"apple", "orange", "banana"}. I can use the functions List.First and List.Last to return "apple" and "banana". However, how can I return the second or Nth record of a list?

Thank you very much in advance.

[ImkeF · Accepted solution]

You can use List.Range for it.

[kroeterix]

This is exactly what I was looking for. Thank you Imke!