SharePoint List Forms: Is Email in Person Column

(0) Share

Report

Posted on by sperry1625

765 Super User 2024 Season 1

I have asked this question before, and received an answer that I thought worked. As it turns out it only partially works.

I have a list with a Person column. The person column allows the user to select multiple people. I need to know if the current user is selected in this column. What I have at the moment is the following:

Set( gblApp, LookUp( AppList, 'Name (Title)' = "AppName" ) );

Set( gblUser, User().Email );

Set( gblIsAdmin, If( gblUser in gblApp.Admins.Email, true, false ) );

This works perfectly, as long as only one person is selected in the Person column. This always returns false when there are multiple people selected.

How do do this check when there are multiple people in the People column? Will that code work against the people column regardless of that number of people selected? I looked at ForAll() but that doesn't seem to be a solution as I cannot use Set or UpdateContext within a ForAll.

Thanks for your assistance.

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

sperry1625 765 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
I solved my own issue. The below worked for me:

Set( gblIsAdmin, If( IsBlank( LookUp( gblApp.Admins, Email = gblUser ) ), false, true ) );

If anyone has a better solution please do not hesitate to respond.

UPDATE: Although the above solution works check out the solution to this post for a solution that works regardless of whether the Person Column is multi select or not.

Thank you.