Getting the Email of the "Created By" Column

[Anonymous]

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?

[nickellis74]

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

[Anonymous]

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

[v-JessicaG-msft]

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

[Anonymous]

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]

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

'

[hiteshn]

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