Lookup values in a collection

Question

ClearCollect(MyCollection, Split("A,B,C", ",")) returns:

[![enter image description here][1]][1]

Answer 1

You can use the AddColumns function to add the 'Name' column into the result of the Split function, something along the lines of

ClearCollect(
    MyCollection,
    AddColumns(
        Split("A,B,C", ","),
        "Name",
        LookUp(MySharePointList, Id = Result, Name)))

Where 'MySharePointList' is your SP list; 'Id' would be the field of that list that you want to match with the 'A'/'B'/'C', and 'Name' is the field of the list that you want to extract.