List.RemoveNulls
Syntax
List.RemoveNulls(list as list) as list
About
Removes all occurrences of "null" values in the list
. If there are no 'null' values in the list, the original list is returned.
Example 1
Remove the "null" values from the list {1, 2, 3, null, 4, 5, null, 6}.
Usage
List.RemoveNulls({1, 2, 3, null, 4, 5, null, 6})
Output
{1, 2, 3, 4, 5, 6}