Getting the Email of the "Created By" Column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

nickellis74 432 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-JessicaG-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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:

Best Regards,

Jessica Gu

1 people found this reply helpful.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Valentijn 21 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
hiteshn 61 on at

Like (1)

Report
Copy link

Link copied!

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'.

Was this reply helpful? Yes No