Building PowerApps Email Template

(1) Share

Report

Posted on by phearin

162

Dear Team,

I want to create email template where I could allow to click on SEND button and it will send the email to respective recipient.

Is it doable in the PowerApps?

To: {the email address}

Title: {Text}

Body:{Text}

Thanks,

Phearin

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

KrishnaV 5,023 on at

Like (2)

Report
Copy link

Link copied!
Hi @phearin ,

Yes, you can 100% do it.
Add Microsoft365Outlook connector.
Microsoft365Outlook.SendEmailV2("email","subject","Body")

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
phearin 162 on at

Like (1)

Report
Copy link

Link copied!

@KrishnaV ,

Thank you for your solution, but I want to make our email template more dynamic where we can customize the body content, not just only text?

For example, Dear Sir/Madam, in this section we want to use data from email or SP list content instead of typing manually.
The body section also can break the line, as in the example for the solution, it will send with single line of text without hierarchy.
I meant the format of email not professional.

Please advise.

Thanks,
Phearin

Was this reply helpful? Yes No
Verified answer

KrishnaV 5,023 on at

Like (1)

Report
Copy link

Link copied!
Hi @phearin ,

Use this email structure see if that works for you or not:
Microsoft365Outlook.SendEmail( "email address here", "Subject", " Bell Customer Report Customer ForeName: "& textInput1.Text & " Customer Surname: "& customerName.Text, { IsHtml:true, Importance: "Normal" } )

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @phearin ,

Does the "To" ComboBox connect to a Person column in your SP List?

Do you want to generate your email content automatically based on the selected option within the ComboBox, the Title Text Input value, and Details Text Input Box?

I have made a test on my side, please consider try the following workaround:

Set the OnSelect property of the "Send Email" button to following:

Microsoft365Outlook.SendEmailV2( ComboBox1.Selected.Email, SubjectBox.Text, "Dear " & ComboBox1.Selected.DisplayName & ", " & RichTextEditor1.HtmlText )

If you want to select multiple person in your "To" ComboBox, please modify above formula as below:

Microsoft365Outlook.SendEmailV2( Concat(ComboBox1.SelectedItems, Email & ";"), SubjectBox.Text, "Dear " & Left( Concat(ComboBox1.SelectedItems, Email & "&"), Len(Concat(ComboBox1.SelectedItems, Email & "&"))-1 ) & ", " & RichTextEditor1.HtmlText )

Please try above solution, hope it could solve your problem.

Regards,

Was this reply helpful? Yes No
phearin 162 on at

Like (1)

Report
Copy link

Link copied!

@KrishnaV

Thank for your enhancement, the solution works.

Thanks,
Phearin

Was this reply helpful? Yes No
phearin 162 on at

Like (1)

Report
Copy link

Link copied!

@v-xida-msft

Could you please assist me if I use richtext editor, is there anyways to put the hyperlink where it is able to link with dynamic filed in SP list?

If not, is there anyways to get it done?

Thanks,
Phearin

Was this reply helpful? Yes No