Answered

Adding User Entered Text into Email Subject

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I'm sending an email upon a user completing my app using Office365Outlook.SendEmailV2. The email lists everything that the user has filled out during the form and i'm wanting one of the results that they have entered in a Text input box to be put in the Subject of the email. The name I have given to the Text input box is Job Number.

Thanks in advance!

Categories:

General Questions

Using Apps Using Formulas

All responses (4)

Answers (1)

Dave-ITMan on at

Like (0)

Report

Re: Adding User Entered Text into Email Subject

That's great thank you so much! I don't suppose you know how I can include the attachments that have been sent in the email to also attach into my sharepoint list do you please using the code above?
Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Re: Adding User Entered Text into Email Subject

ClearCollect(CollectAttachments, AttachmentControl.Attachments); ClearCollect(SignatureCollection, {Signatures:Signature.Image});
Office365Outlook.SendEmailV2("firstname.lastname@companyname.com" , JobNumber.Text , "Hi, 
Please see completed form below and attached images 
<a href=https://companyname.sharepoint.com/sites/PowerApps/Lists/TestForm/AllItems.aspx>Click Here to View the Full SharePoint List</a> 
Customer: "&Customer.Text&" 
Address: "&Address.Text&" 
Job Number: "&'Job Number'&" 
Date: "&Date.SelectedDate&" 

Regards 
{Attachments: AddColumns( RenameColumns (AttachmentControl.Attachments,"Value", "ContentBytes"), "@odata.type", "")});
Patch(TestForm, Defaults(TestForm),
{
Title: ValueDateTimeNow.Text,
Customer: Customer.Text,
'Site Address': Address.Text,
'Job Number': 'Job Number'.Text,
Date: Date.SelectedDate
});
Navigate(Success,Cover)
Dave-ITMan on at

Like (0)

Report

Re: Adding User Entered Text into Email Subject

Hi,
Thanks for the quick reply. I'm not sure what the form ID is referring to? It's the Job number listed that I need to show in the subject of the email.
My code is below if that helps?

ClearCollect(CollectAttachments, AttachmentControl.Attachments); ClearCollect(SignatureCollection, {Signatures:Signature.Image});
Office365Outlook.SendEmailV2("firstname.lastname@companyname.com" , "Subject Here" , "Hi, 
Please see completed form below and attached images 
<a href=https://companyname.sharepoint.com/sites/PowerApps/Lists/TestForm/AllItems.aspx>Click Here to View the Full SharePoint List</a> 
Customer: "&Customer.Text&" 
Address: "&Address.Text&" 
Job Number: "&'Job Number'&" 
Date: "&Date.SelectedDate&" 

Regards 
{Attachments: AddColumns( RenameColumns (AttachmentControl.Attachments,"Value", "ContentBytes"), "@odata.type", "")});
Patch(TestForm, Defaults(TestForm),
{
Title: ValueDateTimeNow.Text,
Customer: Customer.Text,
'Site Address': Address.Text,
'Job Number': 'Job Number'.Text,
Date: Date.SelectedDate
});
Navigate(Success,Cover)
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Re: Adding User Entered Text into Email Subject

Office365Outlook.SendEmailV2(User().Email, JobNumber.Text, "Form ID" & Form.DataCardValue.Text)

You can also use Form.LastSubmited.ID, for example

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!