List.RemoveNulls
List.RemoveNulls(list as list) as list
Removes all occurrences of "null" values in the list
. If there are no 'null' values in the list, the original list is returned.
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}