cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ariel_j
Frequent Visitor

Filter Gallery by Current User where Email Matches People Field

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @ariel_j

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

 

Best Regards,
Qi

View solution in original post

2 REPLIES 2
v-qiaqi-msft
Community Support
Community Support

Hi @ariel_j

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

 

Best Regards,
Qi
ariel_j
Frequent Visitor

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Users online (3,444)