Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Apps Pro Dev & ISV
Answered

Filter Gallery by Current User where Email Matches People Field

(0) ShareShare
ReportReport
Posted on by

How are we able to delegate by user email when the email address we use to login to O365 is not the same as the primary email address.

  • Community Power Platform Member Profile Picture
    on at
    Re: Filter Gallery by Current User where Email Matches People Field

    Hi, the problem was solved using Office365Users.MyProfile().Mail in [SharePoint column name].Email

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on at
    Re: Filter Gallery by Current User where Email Matches People Field

    Hi @Anonymous,

    Have you solved your problem?

    Do you want to get the user email address?

    Could you please share a bit more about the scenario?

     

    Actually, the information returned by User() function is for the current PowerApps user. It will match the "Account" information that is displayed in the PowerApps players and studio, which can be found outside of any authored apps. This may not match the current user's information in Office 365 or other services including SharePoint user profiles. 

     

    As an workaround, I think you should use the Office365Users() to search for this FullName and get user's email address.

    First(Office365Users.SearchUser({searchTerm:User().FullName})).Mail

     

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.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Apps Pro Dev & ISV

#1
WarrenBelz Profile Picture

WarrenBelz 55 Most Valuable Professional

#2
mmbr1606 Profile Picture

mmbr1606 42 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 31 Super User 2025 Season 1

Overall leaderboard