i want to send an email to the submitter(ie, current user) and also to send the email to the Current users manager.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a submit screen with list of fields like User, Manager of the user and Title. Here the

*User is a current user so it automatically displays the User Name(Name_TextInput2.Text) by Hard coded -

Office365Users.MyProfile().DisplayName.

*And to get the Manager of the entered user by default(emp_Text22) by Hard coded-
If(!IsBlank(Name_TextInput2.Text), Office365Users.Manager(First(Office365Users.SearchUser({searchTerm: Name_TextInput2.Text})).Mail).DisplayName). This works fine.

Needed is: i need two different emails to send for two different screens.

1)Now if i click the submit its wants to send the email to both the user and the manager depends on the name in the Manager text box field(emp_Text22) and with the html content of the submitted values.

2)For another screen i have a Data Table to store the submitted records. So all the users entries records are stored in DataTable1_1. if i select any one of the record in table then click submit ,the mail wants to send to the name of the employee as well as to the employee manager. I hardcore like this its shows error and didn't receive the mail too.

Clear Collect(Recipients,Office365Users.Manager(User().Email).Mail);
Office365Outlook.SendEmail(Concat(Recipients,Value&";"),"Emp Request","<table>"&DataTable1_1.Selected.'Name of employee'&",<tr><tr><tr>Your Request for " &DataTable1_1.Selected.Destination& " on " &DataTable1_1.Selected.'Departure date'& " was " &AppRej_Radio_1.Selected.Value&" by " &User().FullName&" <td><tr><tr>comments: </td></tr></tr>"&Comments_TextInput1_1.Text&"</table>",{Cc:"",Importance:"High"});

please help. Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
Firstly, your Clear Collect should be ClearCollect - correct this and see what the collection called Recipients looks like.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

In Powerapp ClearCollect is hard-coded in the way you mentioned. But still its showing error and didn't get the email once i click submit. please clarify my needs.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

i already have email coded like this to submitter but now i also want to send email with Cc to the current user's Manager(TextInput2).

// Send email to submitter
Office365Outlook.SendEmailV2(First(Office365Users.SearchUser({searchTerm:DataTable1.Selected.'Name of employee'})).Mail," Request","<table>"&DataTable1.Selected.'Name of employee '&",<tr><tr><tr>Your Request for " &DataTable1.Selected.Destination& " on " &DataTable1.Selected.'Departure date'& " was " &AppRej_Radio1.Selected.Value&" by " &User().FullName&" <td><tr><tr>comments: </td></tr></tr>"&Comments_TextInput1.Text&"</table>",{Cc:"",Importance:"High"});

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Sorry - I just spotted what I thought was an obvious error.
I am not an O365 directory user - I will tag one of my colleagues @mdevaney to see it he can assist.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

yeah, Ok. Please do the needful.

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

Like (0)

Report
Copy link

Link copied!

@Anonymous

Do I understand correctly that the problem is you are trying to send an email but nothing happens? I think it would be best to narrow the list of possible issues. Please try both of these tests.

#1 Change the connector to SendEmailV2. You should never use SendEmail since it is deprecated and could be deleted at any time by Microsoft.

Office365Outlook.SendEmailV2(
Concat(Recipients,Value&";"),
"Emp Request",
"<table>"&DataTable1_1.Selected.'Name of employee'&",<tr><tr><tr>Your Request for "
&DataTable1_1.Selected.Destination& " on " &DataTable1_1.Selected.'Departure date'& " was "
&AppRej_Radio_1.Selected.Value&" by " &User().FullName&" <td><tr><tr>comments: </td></tr>
</tr>"&Comments_TextInput1_1.Text&"</table>",
{Cc:"",Importance:"High"}
);

#2 Try inputting your own email address in the 1st argument and attempt to send the email. If you receive an email there is any issue with your Concat statement or recipients collection.

Office365Outlook.SendEmailV2(
"yourname@yourcompany.com",
"Emp Request",
"<table>"&DataTable1_1.Selected.'Name of employee'&",<tr><tr><tr>Your Request for "
&DataTable1_1.Selected.Destination& " on " &DataTable1_1.Selected.'Departure date'& " was "
&AppRej_Radio_1.Selected.Value&" by " &User().FullName&" <td><tr><tr>comments: </td></tr>
</tr>"&Comments_TextInput1_1.Text&"</table>",
{Cc:"",Importance:"High"}
);

---
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
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Please take a time to look on it and do favor.
I have a submit screen with list of fields like User, Manager of the user and Title. Here the
*User is a current user so it automatically displays the User Name(Name_TextInput2.Text) by Hard coded -
Office365Users.MyProfile().DisplayName.
*And to get the Manager of the entered user by default(emp_Text22) by Hard coded-
If(!IsBlank(Name_TextInput2.Text), Office365Users.Manager(First(Office365Users.SearchUser({searchTerm: Name_TextInput2.Text})).Mail).DisplayName). This works fine.

Needed is: i need two different emails to send for two different screens.
1)Now if i click the submit its wants to send the email to both the user and the manager depends on the name in the Manager text box field(emp_Text22) and with the html content of the submitted values.
2)For another screen i have a Data Table to store the submitted records. So all the users entries records are stored in DataTable1_1. if i select any one of the record in table then click submit ,the mail wants to send to the name of the employee as well as to the employee manager. How to add Manager as Cc in mail?. I hardcore like this its shows error and didn't receive the mail too.

Clear Collect(Recipients,Office365Users.Manager(User().Email).Mail);
Office365Outlook.SendEmail(Concat(Recipients,Value&";"),"Emp Request","<table>"&DataTable1_1.Selected.'Name of employee'&",<tr><tr><tr>Your Request for " &DataTable1_1.Selected.Destination& " on " &DataTable1_1.Selected.'Departure date'& " was " &AppRej_Radio_1.Selected.Value&" by " &User().FullName&" <td><tr><tr>comments: </td></tr></tr>"&Comments_TextInput1_1.Text&"</table>",{Cc:"",Importance:"High"});

please help. Thanks in advance

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

Like (0)

Report
Copy link

Link copied!

@Anonymous

You have simply copied and pasted the text from your original post here.

Did you try my suggestions? Please tell me what happened for each of #1 and #2?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

#1 still the same problem persist. Didnt send mail..
#2 Second one works fine. Now I got a mail. but what i need is once i click submit mail wants to send to user as well as the manager of the current user

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

Like (0)

Report
Copy link

Link copied!
@Anonymous

As a test, put each of these in a new Text label inside your app. What do they show?

User().Email
Office365Users.Manager(User().Email).Mail

If the emails show correctly load them into a SET variable

Set(emailTo, User().Email & "; " & Office365Users.Manager(User().Email).Mail & ";")

Then use the SET variable in your code to SendEmailV2

Office365Outlook.SendEmailV2(
emailTo,
"Emp Request",
"<table>"&DataTable1_1.Selected.'Name of employee'&",<tr><tr><tr>Your Request for "
&DataTable1_1.Selected.Destination& " on " &DataTable1_1.Selected.'Departure date'& " was "
&AppRej_Radio_1.Selected.Value&" by " &User().FullName&" <td><tr><tr>comments: </td></tr>
</tr>"&Comments_TextInput1_1.Text&"</table>",
{Cc:"",Importance:"High"}
);

Make sure to use SendEmailV2. Let me know the result.

---
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