Finds the first occurrence of any value in values and returns its position.


List.PositionOfAny(list as list, values as list, optional occurrence as nullable number, optional equationCriteria as any) as any  


Argument Description
list The List to check.
values The list of values to check for.
optional occurrence An enum that controls the scope of operation.
optional equationCriteria An optional equation criteria value to control equality comparisons. For more information about equality comparisons, see Parameter Values .

Occurrence settings

Setting Description
Occurrence.First and Occurrence.Last Returns a single position.
Occurrence.All Returns a list of positions with all occurrences.


  • If the value is not found in the list, -1 is returned


List.PositionOfAny({"A", "B", "C", "D"}, {"B", "C"}) equals 1  
List.PositionOfAny({"A", "B", "C", "B", "A"}, {"A", "B"}, Occurrence.First) equals 0
List.PositionOfAny({"A", "B", "C", "B", "A"}, {"A", "B"}, Occurrence.Last) equals 4  
List.PositionOfAny({"A", "B", "C", "B", "A"}, {"A", "B"}, Occurrence.All) equals {0, 1, 3, 4}