← Back to List functions

List.Buffer

The list is stored in memory buffers. This function ensures that the list is stable, meaning it will have a consistent number of items and maintain the same order.

Syntax

List.Buffer(list as list) as list

About

The list is stored in memory buffers. This function ensures that the list is stable, meaning it will have a consistent number of items and maintain the same order.

Explanation

Generate a secure duplicate of the list containing numbers from 1 to 10. To do so, utilize the Power Query function MList.Buffer({1..10}). The output will be {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}.