Unanswered

How to get email from a SharePoint list column of type 'Person or Group'

(0) Share

Report

Posted on by SachS

151

I have a simple SharePoint list (MyUserList) with two columns; Title and User, with User being of type 'Person or Group'. The list will be maintained by a person within the company and they will add/remove company users to the list.

In my app, I would like to see if the current user is in this list (by comparing email address), and set a variable to true if so. Essentially, something like this:

Set(
 IsUserInMyList,
 If(
 User().Email in MyUserList.User.Email,
 true,
 false
 )
);

But this gives me an error at the 'MyUserList.User.Email' section saying "Name isn't valid. This identifier isn't recognized". Basically, it can see the 'User' object, but not the email within.

Is there a way to read a SP list with a 'Person or Group' column and get the email?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (1)

Report
@SachS
Your formular will look something like that:

Set(varCurrentUserExists,!IsBlank(LookUp(MyUserList,User.Email = User().Email)));

So what the formular actually does is to try to find an item where the current user email is found in the the column User. If yes it will return a record. With IsBlank() we check if the record contains data...this is only the case when the users is in the list. So IsBlank() will return true if NO item is found. With ! before IsBlank() we want to get the oposit. So true will become false .....false would become true.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report

@SachS ....I have updated my formular because of an typo....

Was this reply helpful? Yes No
SachS 151 on at

Like (0)

Report

Yes, I actually figured out I needed the NOT in front, but it worked, thanks!

Was this reply helpful? Yes No