How to get another user's email

(0) Share

Report

Posted on by Radoslavov

817

Hi all, I'm building this application that has to send an email to a person who created an item in SPO list.

I have jb007MI6 field in my view form in Power Apps coming from SPO list, however I'm trying to get the persons email so I can send him an email.

Office365Outlook.SendEmailV2('Created By_DataCard1'.DataField, "New onboarding request for " & varRecord.'First Name' & " " & varRecord.'Last Name' & "has been created", "Here is a link to the record <ahref='https://apps.powerapps.com/play/306d698a-804a-4d77-b82a-e7fe447de163?tenantId=8527ffd7-e153-4862-bf90-7a0cab40241e&hidenavbar=true&EmpID=" &varRecord.ID & "'>link</a> here.")

I'm using deep linking function to do so, here is the formula, but i don't know how to get Created By user's email and not display name.

PS: the trick with changing created by filed settings to show email address instead of display name is not working.

I know i can achieve this by story the email address in a separate column, but I'm trying to avoid having extra columns, since by default i have created by person, so i only need to get his email address from O365 directory.

Regards

Kiril

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

shoog 2,164 on at

Like (1)

Report
Copy link

Link copied!
Does varRecord hold the SPO list item you want to use?
If that's the case, you can use
varRecord.'Created By'.Email

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like (0)

Report
Copy link

Link copied!
@Radoslavov ,

Inside the 'Created By_DataCard1' there is a control (most probably a combobox) called DataCardValue ... . Use it to reference the created by person's email with DataCardValue.Selected.Email.

Like this:

Office365Outlook.SendEmailV2(DataCardValue.Selected.Email, "New onboarding request for " & varRecord.'First Name' & " " & varRecord.'Last Name' & "has been created", "Here is a link to the record <ahref='https://apps.powerapps.com/play/306d698a-804a-4d77-b82a-e7fe447de163?tenantId=8527ffd7-e153-4862-bf90-7a0cab40241e&hidenavbar=true&EmpID=" &varRecord.ID & "'>link</a> here.")

Hope it helps !

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If it's a SharePoint Online column, You can just use CreatedBy.Email or sometimes it is Author.Email

Was this reply helpful? Yes No
Radoslavov 817 on at

Like (0)

Report
Copy link

Link copied!

Thank you @shoog, I can believe it was that simple, I've tried taking it from the varRecord, but I didn't put .Email after created by.

Thank you and @gabibalaban, and @zmansuri for the time looking into my problem.

Appreciate everyone's help.

Stay safe and regards
Kiril

Was this reply helpful? Yes No