Answered

Navigating Collection from SharePoint List with Person "Allow Multiple Selections" Enabled

(0) Share

Report

Posted on by AylardJ

I think I'm skating around the edges of something that should be obvious, but I haven't figured it out yet. I have found similar questions asked before, but as applied they don't seem to be the answer.

My question: I am creating a collection from a SharePoint list that includes a People column that has the "Allow Multiple Selections" option enabled. So, in other words, the People column can potentially be an array, and even single-entry records are treated as an array, from what I can tell.

I want to perform a LookUp against the Claims property of each Person entry in a specific row to see if it matches a particular individual based on email address, and then extract the DisplayName property for that Person entry. When I have the "Allow Multiple Selections" option disabled, this is fairly easy:

LookUp(
 MyCollection,
 Person.Claims = "i:0#.f|membership|" & strTargetEmail,
 Person.DisplayName
)

But when that Person entry is an array, this doesn't work. I think the answer is probably pretty straightforward, but I can't see the forest for the trees. Can someone help clear up my confusion? Thanks.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@AylardJ

Please consider changing your Formula to the following:

LookUp( MyCollection, "i:0#.f|membership|" & strTargetEmail in Person.Claims, Person.DisplayName )

I hope this is helpful for you.
AylardJ 34 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes, thank you for your reply and your suggestion. This has gotten me closer, but the value, which I expected to be a string, is being returned as a table. When I look at the variable I've created to hold that value, I can drill down to find that the lone value contained in the table is the DisplayName that I expect. What additional step do I need to take to return the value as a string and not embedded in a table?
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@AylardJ

Sorry...completely missed the "Multi-Person" part of this:

In this case you kind of have to double lookup...once for the initial record and then to find the record in that record.

So:

With({_users:LookUp(MyCollection, "i:0#.f|membership|" & strTargetEmail in Person.Claims).Person}, LookUp(_users, "i:0#.f|membership|" & strTargetEmail in Claims, DisplayName) )

Should give you what you want.
AylardJ 34 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes, that was the solution. Thank you!