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

Community site session details

Session Id : 0N021yvudIcCde0d/aUfMW
Power Platform Community / Forums / Power Apps - Building Power Apps / Getting the Email of t...
Power Apps - Building Power Apps
Unanswered

Getting the Email of the "Created By" Column

Like (0) ShareShare
ReportReport
Posted on 25 Nov 2021 09:13:46 by Community Power Pla...

I have a "Created By" column in my dataverse table but when I try to use ThisItem.'Created By', there's no email field.

I tried to use ThisItem.'Created By'.'Primary Email' but that returns a blank. 

How do I get the Email?

 

Jimmyseow_0-1637831025718.png

 

Categories:
Connecting to Data
dataverse email.jpg
I have the same question (0)
  • nickellis74 Profile Picture
    nickellis74 430 Moderator on 25 Nov 2021 at 09:59:07
    Re: Getting the Email of the "Created By" Column

    I believe you need the 'Preferred Email' field. I had this problem as well and that was the solution that worked for me.

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 25 Nov 2021 at 14:10:36
    Re: Getting the Email of the "Created By" Column

    Unfortunately, that returns 'Blank' as well as do "Email 2".

  • v-JessicaG-msft Profile Picture
    v-JessicaG-msft on 26 Nov 2021 at 09:38:07
    Re: Getting the Email of the "Created By" Column

    Hi @Anonymous ,

     

    Do you want to get the email in "Created By" Column?

     

    You could check in the Dataverse whether the “email” field in the table corresponding to the lookup relationship in the "Created By" Column has been renamed, and check whether the primary Email field in the User table is also empty. If all are empty, you could find the field that stores the email, and select the corresponding field in the formula to get the Email. Please refer to the screenshot below:

    vJessicaGmsft_0-1637918856356.jpeg

    vJessicaGmsft_1-1637919113614.png

    vJessicaGmsft_2-1637919357824.png

     

    Best Regards,

    Jessica Gu

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 26 Nov 2021 at 15:12:32
    Re: Getting the Email of the "Created By" Column

    Just to clarify, my app is a Microsoft Teams App and not the main PowerApps.

    I did find the Users table in the main PowerApps and when I filtered for my name, it returned the Primary Email address correctly.

    Unfortunately, using ThisItem.'Created By'.'Primary Email' in Microsoft Teams App does not give me the right value. It's just a blank.

  • Valentijn Profile Picture
    Valentijn 21 on 01 May 2023 at 21:25:29
    Re: Getting the Email of the "Created By" Column

    'Created By' is a record. I used a label  to resolve the e-mailadres. text = datacard_CreatedBy.Selected.'primary address'

    '

  • hiteshn Profile Picture
    hiteshn 61 on 25 Jan 2024 at 12:58:30
    Re: Getting the Email of the "Created By" Column

    I was also stucked in this situation. I want to filter the dataverse table based on the current user. This worked for me.

     

    'Created By'.'Primary Email'
    this will give you email address.
     
    Filter is below:
    Filter('Table Name',Lower(User().Email) = Lower('Created By'.'Primary Email'))
     
    Remember to use lower function in filter, since User().email gives you camelcase and createdby gives smallcase, otherwise it won't work.
     
    Want to use it in gallery, below:
    ThisItem.'Created By'.'Primary 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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 686 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 433 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 266 Moderator

Last 30 days Overall leaderboard

Featured topics

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

Product updates

Microsoft Power Platform Community release plans