Extracting Items from Multiple selection Lookup Column

(0) Share

Report

Posted on by lewiscarr81

BACKGROUND:

I have a SharePoint List, and one of the Columns is a Lookup Column where multiple items can be selected.

PROBLEM:

I need to be able to lookup one record and extract all the items chosen in this column and then add them to a collection.

EXAMPLE:

Column Name is Area. Selected Items are London, South Wales, Cornwall.

I need a Collection of 3 items:

London

South Wales

Cornwall

I have searched everywhere for the answer including attempts of my own. Any help would be appreciated.

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@lewiscarr81 - see example below:

ClearCollect( MyCollection, Split( Concat( LookUp( 'Your SharePoint List', ID = 1, 'Your Multi Choice Lookup Column' ), Value, "," ), "," ) )
lewiscarr81 14 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik thanks for your reply. I get an error that the Concat has issues.

ClearCollect(
MyCollection,
Split(
Concat(
LookUp(
'Notification Profiles',
User.Email = User().Email,
Area //My SP Column Name
),
Value,
","
),
","
)
)
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@lewiscarr81 - could you share a screenshot of the error message.
lewiscarr81 14 on at

Like
a
(0)

Report
Copy link

Link copied!
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@lewiscarr81 - could you confirm your multi choice field is set to allow multiple values in SharePoint? (not just the app).
lewiscarr81 14 on at

Like
a
(0)

Report
Copy link

Link copied!

@Amik You're correct it is the case in SP.
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@lewiscarr81 - adding @WarrenBelz who might notice something obvious.
WarrenBelz 156,736 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Thanks @Amik ,

I am a little unclear on how these values are "selected", but if from a Combo Box allowing multiple selections, this should get all the records in the lookup up list matching the elected items.

ClearCollect( MyCollection, ForAll( ComboBoxName.SelectedItems As _Data, LookUp( 'Notification Profiles', Area = _Data.Value ) ) )