How to use a filter when the user has mutliple email addresses?

(1) Share

Report

Posted on by ConnM

260

Hi all

I was wondering what is the correct way to write a filter when a user has more than one email address attached to their AD account.

We no longer allow users to have multiple email accounts, but there are a handful that have been grandfathered in, with an account for Tim and Timothy, for example.

I have a SharePoint list that has a person column "Assigned To". I want to filter the list so the user only sees items that have been assigned to them.

I am aware that others have encountered issues with the handful of people with multiple accounts before, what can i do to guarantee that they see their items?

Thanks Very Much

Conn

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Pro_User_365 546 on at

Like (1)

Report
Copy link

Link copied!
Hi @ConnM ,
Try this code.

Filter(YourSharePointList, 'Assigned To'.Email = User().Email)

This filter will match the primary email address of the user with the email addresses in the "Assigned To" column and display items assigned to them.
Note: After receiving the answer, if you think it's helpful, please consider accepting it. 😊 Regards! Ali Shahzad

Was this reply helpful? Yes No