Answered

Get email address from Person picker field

(0) Share

Report

Posted on by biancadevera

I would like to get the email address from a person field in the SP list I created so I can use it to compare for User().Email. How can I do this? I'm trying to use it for the gallery that should only show items if the current logged in user matches the User (person field). I also have multiple users enabled for the column.

Please help.

I have the same question (0)

All responses (3)

Answers (1)

v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Re: Get email address from Person picker field

Hi @biancadevera ,

Please try:
Filter(AddColumns(listD,"memberEmail",Concat(member,Email,",")),User().Email in memberEmail)

Best Regards,
Dezhi

Was this reply helpful? Yes No
biancadevera on at

Like (0)

Report

Re: Get email address from Person picker field

Hi @v-dezhili-msft ,

This works like charm! I have another question tho. Say I have another column but this time just single user is allowed. How can I do that? Basically, my gallery will depend on two columns (person field). When the user's email is in any of the columns, it should show the items assigned to him.

Appreciate your help!

Was this reply helpful? Yes No
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report
Re: Get email address from Person picker field

Hi @biancadevera ,

Just add another condition to the filter.
Filter(AddColumns(listD,"memberEmail",Concat(member,Email,",")),User().Email in memberEmail||User().Email=member2.Email)

Best Regards,
Dezhi

Was this reply helpful? Yes No