web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Email ID from User loo...
Power Apps
Unanswered

Email ID from User lookup column

(0) ShareShare
ReportReport
Posted on by Shiva 16

Hello,

 

I am using dataverse table. A column named 'Assigned User' is a Lookup from 'User' table. In power app edit form, I have 'Assigned User' it apprise as searchable dropdown list with users and groups. However, I am getting all properties blank except 'FullName'

 

I used cmbDataCardValue.Selected.'Email 2'. I could see only 'Email 2' property there is no Mail. Even 'Primary Email' is also blank.

cmbDataCardValue is the combo box in Assigned User data card.

I am supposed to send email to 'Assigned User' on submission.

 

Thanks 

Categories:
Building Power Apps
  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    If your User table is anything like the SystemUser table/entity, try "internalemailaddress":

     

    SystemUser table/entity reference (Microsoft Dataverse) - Power Apps | Microsoft Docs

  • Shiva Profile Picture
    Shiva 16 on at

    Thanks for the quick reply.

     

    Yes I am using System table. looks like i am missing something. I don't see the property "internalemailaddress" incmbDataCardValue.Selected. this is what you were suggesting or I am not on correct path.

     

    Thanks

  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Can you share the code for cmbDataCardValue.items?

  • Shiva Profile Picture
    Shiva 16 on at

    Choices([@'Assignments table'].ssp_assigneduser)

  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    I think the issue is that the data-source is not the User table directly, but through the lookup. 

     

    To retrieve the mail address that belong to the assigneduser, you can use the FullName as the key:

     

    Something like:

     

     

    Search(Users, fullname = cmbDataCardValue.Selected.FullName, internalemailaddress)

     

    or 

     

    Search(Users, 'Full Name'= cmbDataCardValue.Selected.FullName, 'Primary Email')

     

  • Shiva Profile Picture
    Shiva 16 on at

    No Luck ☹️. It did not work.

  • BCBuizer Profile Picture
    BCBuizer 22,854 Super User 2026 Season 2 on at

    Sorry, what did you try for it not to work?

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans