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.
Hi @biancadevera ,
Please try:
Filter(AddColumns(listD,"memberEmail",Concat(member,Email,",")),User().Email in memberEmail)
Best Regards,
Dezhi
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!
Just add another condition to the filter.
Filter(AddColumns(listD,"memberEmail",Concat(member,Email,",")),User().Email in memberEmail||User().Email=member2.Email)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 757 Most Valuable Professional
Michael E. Gernaey 322 Super User 2025 Season 2
MS.Ragavendar 209 Super User 2025 Season 2