Send e-mail : how to complete "From" automatically ?

[RSygroves]

Hello,

I'm making a new (quite simple) app for my company, that will be integrated to our sharepoint website.

Here is the situation : we have numerous softwares and website that may be used by our employees.

To help them (especially new ones) understanding which use every software is made for, i created a sharepoint list with several details.

There is no form in my app, because I don't want users to add anything to the list.

But, I would like user to press a button (for each item) to send me an e-mail access request if they need it.

I have no problem setting up the "send email" feature.

But what should I write in the formula to have the name of the user appear as "from" (or at least in the e-mail body) without asking them to write it ?

(knowing they will use it will navigating (and then being connected with their O365 address on the website)

Thank you !

Best regards,

Romain

[Gorilla_8]

@RSygroves 

Hi,

Try to use the connector: 

Office 365 Users

And then: Office365Users.MyProfile().DisplayName use this function to get the email from the user.

So when the user clicks on send, you put this after the "from" Office365Users.MyProfile().DisplayName to get the name, if you want the email use this one: 

Office365Users.MyProfile().mail

 

[RSygroves]

Thank you @Gorilla_8

for the moment I set up My button "OnSelect" property as :

Office365Outlook.SendEmailV2("zzz@yyy.fr";"Subject";"Body " & ThisItem.Title)

Could you help regarding where to put the "Office365Users.MyProfile().DisplayName" formula ?

I added the Office365Users connector, but can't figure out how to write it the above property as I would like to have something like  "UserX asks access to ///" as e-mail body where "UserX" should be the user's DisplayName and "///" is the software (this part works fine with "ThisItem.Title")  

[AaronKnox]

You don't need to do anything to accomplish this!  The Outlook connector will use the mailbox of the person logged in to send the email.  It will always be From: the person using the app.

[RSygroves]

Thank you @AaronKnox but in this case I must confess I know even less how (and where) to set it up !

😬

[AaronKnox]

Add this to the button's OnSelect and then ALT-Click the button to see how it works. 

Office365Outlook.SendEmailV2(  
User().Email, 
"Subject Goes Here", 
"Body Goes Here" 
);

This will send an email To: you From: you, a 'note to yourself'.  Replace User().Email with someone else's email and they will receive it From: you.

[RSygroves]

Hi @AaronKnox 

thanks for your advice.

I just tried this option, it seems to work as the e-mail is actually sent.

But when another user tries it, it sends the e-mail to his own account, whereas I'd like it to always send it to the same single recipient (= myself).

I'm going to check what can be set up to solve the issue.

[AaronKnox · Accepted solution]

You can hard-code your email like this

Office365Outlook.SendEmailV2(  
"RSygroves@RSygroves.com", 
"Subject Goes Here", 
"Body Goes Here" 
);

Below has all options.  I'll start with this template and then fill in the blanks

Office365Outlook.SendEmailV2(
 "", 
 "Subject", 
 "Body", 
 {​​​​​​ 
  Cc: "",  
  Bcc: "", 
  Importance: "High" 
 }​​​​​​ 
);