List.RemoveNulls
Removes all "null" values from the specified list.
Syntax
List.RemoveNulls(
list as list
) as list
Remarks
Removes all occurrences of "null" values in the list
. If there are no 'null' values in the list, the original list is returned.
Examples
Example #1
Remove the "null" values from the list {1, 2, 3, null, 4, 5, null, 6}.
List.RemoveNulls({1, 2, 3, null, 4, 5, null, 6})
Result:
{1, 2, 3, 4, 5, 6}
Category
List.Transformation functions