Table of contents
TOC
Collapse the table of content
Expand the table of content

List.Alternate

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns a list with the items alternated from the original list based on a count, optional repeatInterval, and an optional offset.

List.Alternate(list as list, count as number,  optional repeatInterval as nullable number,  optional offset as nullable number) as list  

Arguments

ArgumentDescription
listThe List to modify.
countAlternate count.
optional repeatIntervalAlternate repeat interval.
optional offsetAlternation offset.

Remarks

If the repeatInterval and offset are not provided then List.Alternate is equivalent to List.Skip.

Example

List.Alternate({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 2, 2, 0) equals {3, 4, 7, 8}  
© 2018 Microsoft