Send email to the User what the user has just submitted in SharePoint List.

(0) Share

Report

Posted on by akbarmahfuzalam

709

Hello everyone,

I am struggling to get the Formula for the Button.

Ask- I want to press a button and email should trigger the desired recipient which is in the Inputbox.

I have galley called ProcessKnowledgeTestGallery when submitting the gallery data it's storing into SharePoint List named ProcessKnowledgeTest.

Now I want to assign a new button Email send. When Click it should send the current data which the user had just submitted from Gallery to Sharepoint List.

The email needs to send as an attachment.

Step by Step help is appreciated as I am new to Powerapps.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@akbarmahfuzalam
I can show you how to send a message using the gallery data in the body of the email. Let me know if you want my help with. I cannot do it as an attachment.

If yes, please send a screenshot of your app so I can come up with some example code.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying to my concern.

Here we go with a screenshot .

On my Submit Button

Please let me know if you need any other info.

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@akbarmahfuzalam
You didn't answer my question. I can't send as attachment.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

No Problem,
If I am able to showcase the user what they have just submitted in SP at that very moment and it can be sent as a body in the email as a table format. I am Good with that. Please go ahead with your solution what shall I put in the formula bar Onselect.
Eagerly waiting for your response.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey I answered you .

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey I answered you. I am okay if there is no attachment.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there someone else who can help me with the above mentioned subject. I would be highly obliged.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@akbarmahfuzalam

If you can forego the attachment and simply send as the body of the email, it would be much easier to start.

All you need do is generate the HTML that will be the body and then perform a SendEmail on it.

I'm not sure if you are stating that you want the email to be generated after submit, or if you want it to be its own separate button.

Here is an example of it on it's own button (if you want it on the submit, then just add this to the end of your Submit formula).

NOTE: This is shortened to be an example for you and only includes the first 4 columns of your Gallery - you can take the example and complete for the rest of your columns (please excuse any typos...doing this on the fly):

With( {myEmailBody: "<html><head></head> <body> <p>Please note the follwing items were submitted by " & User().FullName & " on " & Now() & "</p> <table> <tr><th>Date</th><th>Week</th><th>Month</th><th>SAP</th></tr>" & Concat(ProcessKnowledgeTestGallery.AllItems, "<tr><td>" & PKTDate.SelectedDate & "</td> <td>" & PKTWeek.Text & "</td> <td>" & PKTMonth.Text & "</td> <td>" & SAPID.Text & "</td> </tr>" ) & "</body> </html>" }, Office365Outlook.SendMail(yourTextInputControl.Text, "Records submitted (or whatever Title you want)", myEmailBody, {IsHtml:true} )

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Randy,

Thanks for your help. It really means a lot to me.

the entire code

With(
{myEmailBody:
"<html><head></head>
<body>
<p>Please note the follwing items were submitted by " & User().FullName & " on " & Now() & "</p>
<table>
<tr><th>Date</th><th>Week</th><th>Month</th><th>SAP</th><th>EID</th><th>LOB</th><th>QUEUE</th><th>OpportunityEarned</th><th>TotalOpportunity</th><th>UploadedBy</th></tr>" &

Concat(ProcessKnowledgeTestGallery.AllItems,
"<tr><td>" & PKTDate.Text & "</td>
<td>" & PKTWeek.Text & "</td>
<td>" & PKTMonth.Text & "</td>
<td>" & SAPID.Text & "</td>
<td>" & EID.Text & "</td>
<td>" & LineOfBusiness.Text & "</td>
<td>" & Queue.Text & "</td>
<td>" & TextInputOpportunityEarned.Text & "</td>
<td>" & TextInputTotalOpportunity.Text & "</td>
<td>" & UploadeBY.Text & "</td>
</tr>"
) &
"</body>
</html>"
},
Office365Outlook.SendEmailV2(TextInputEmail.Text,
"Records submitted (or whatever Title you want)",
myEmailBody,
{IsHtml:true}
)

While incorporating the code which you have given to me. it works quite well until the " Office365Outlook.SendEmailV2(TextInputEmail.Text,
"Records submitted (or whatever Title you want)",
myEmailBody,
{IsHtml:true}

So there is an error on {IsHtml:true}
No Parameter: This Funtion has no optional Parameter named 'IsHtml'

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@akbarmahfuzalam

Yep...as mentioned

please excuse any typos...doing this on the fly)

Please add a ")" to the end of the entire formula:

With( {myEmailBody: "<html><head></head> <body> <p>Please note the follwing items were submitted by " & User().FullName & " on " & Now() & "</p> <table> <tr><th>Date</th><th>Week</th><th>Month</th><th>SAP</th></tr>" & Concat(ProcessKnowledgeTestGallery.AllItems, "<tr><td>" & PKTDate.SelectedDate & "</td> <td>" & PKTWeek.Text & "</td> <td>" & PKTMonth.Text & "</td> <td>" & SAPID.Text & "</td> </tr>" ) & "</body> </html>" }, Office365Outlook.SendMail(yourTextInputControl.Text, "Records submitted (or whatever Title you want)", myEmailBody, {IsHtml:true} ) )

Was this reply helpful? Yes No