List.InsertRange is a Power Query M function that inserts a range of values into a list at a specified index. The function returns a new list with the values inserted at the given index.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
List.InsertRange(
list as list,
index as number,
values as list,
) as list| Argument | Attribute | Description |
|---|---|---|
| List | The list where you aim to insert new values. | |
| Index | The index position of the original list where values are insert into. This follows the zero-based indexing system, meaning the first position is referred to as 0. | |
| Values | A list of values you wish to insert into your main list. |
Description
The List.InsertRange function is helpful when it comes to inserting values into lists. Executing the List.InsertRange function results in a new list. This list contains the values from the ‘Values’ argument inserted at the specified ‘Index’ within the original ‘List’.
Examples
Let’s see some examples of how to use the List.InsertRange function.
Consider you have the list {0, 1, 2} and you intend to introduce the numbers -1 and -2. To position them at the second position, provide an index of 1 due to the zero-based indexing system.
// Output: { 0, -1, -2, 1, 2 }
List.InsertRange(
{ 0, 1, 2 },
1,
{ -1, -2 }
)This generates a newly-formed list with the values inserted at your chosen index.
A point to note: if you attempt to insert values at a location beyond the existing number of elements in your list, Power Query raises an error:
// Output: { error }
List.InsertRange(
{ 0, 1, 2 },
5,
{ -1, -2 }
)Related articles
Learn more about List.InsertRange in the following articles:
- Lists in Power Query M / List Functions (200+ Examples)
The complete guide to Lists in Power Query M. Learn from practical examples and master Power Query’s most powerful List functions. » Read more
Related functions
Other functions related to List.InsertRange are:
