CODEWITHSUNDEEP
powerappspowerapps-formulapowerapps-collection
user882670
user882670

Reputation:

Lookup values in a collection

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

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

Upvotes: 0

Views: 3830

Answers (1)

carlosfigueira
carlosfigueira

Reputation: 87293

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.

Upvotes: 0

Related Questions