Sending mail to multiple users from a Text field populated User Display Name

[BhavithShetty]

Hello,

I have created a PowerApps as a ticketing system, The main issue i am facing while send emails to the multiple users.

Whenever I am clicking Create ticket button, it should send mail to the multiple users with ticket has been created as a mail body,

My txtLead is the Text Input input field where the DisplayName of The users are populated.

This is the code for on Select Property for Submit ticket button 

// Define variables for SharePoint list names
Set(
Attachment,
TRequests
);
Set(
recID,
Patch(
TRequests,
Defaults(TRequests),
{
Description: Text(txtdescription),
Subject: Text(txtsubject),

Dept_1: { Value: Dropdown2.Selected.Value },

Request_Date: Date Value(TextInput5.Text),
Ticket_Status: { Value: "New" },
On_Behalf_of: If(
IsBlank(ComboBox2.Selected),
Blank(), {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & ComboBox2.Selected.Mail,
Department: "", // Set to current value
DisplayName: ComboBox2.Selected.DisplayName,
Email: ComboBox2.Selected.Mail,
JobTitle: "", // Set to current value
Picture: "" // Set to current value
}
),
Status: { Value: "Unassigned" },
Lead: Concatenate(
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead.Email,
",",
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead2.Email,
",",
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead3.Email,
",",
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead4.Email,
",",
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead5.Email
)
}
).ID
);

// Loop through attachments and save them along with their URLs
ForAll(
DataCardValue8_1.Attachments,
SaveAttachment.Run(
recID,
{
file: {
contentBytes: Value,
name: Name
}
}
)
);

//Use the variables in the Patch functions
Notify(
"Request added successfully.",
NotificationType.Success
);

If(CountRows(Errors(TRequests)) > 0,
Notify("Error creating ticket. Check the app logs for details.", NotificationType.Error);
ForAll(Errors(TRequests), Log("Error creating ticket: " & JSON(recID,JSONFormat.IncludeBinaryData)))
);

//Reset controls and navigate to the desired screen
Reset(txtdescription);
Reset(txtsubject);
Reset(Dropdown2);
Reset(TxtLead);
Reset(DataCardValue8_1);
Navigate(
Screen1,
ScreenTransition.Fade
);

// send email notifications to the member
Office365Outlook.SendEmail(
TextInput1.Text, // Assuming TextInput1 contains the email address of the recipient
"[Ad-hoc Request]",
"Thank you for submitting a request to the BSG operating service team. Your Ticket Number is " & recID,

{
Importance: "Normal",
IsHtml: true
}
);

Office365Outlook.SendEmail(
TxtLead, // Assuming TextInput1 contains the email address of the recipient
"[Ad-hoc Request]",
"Thank you for submitting a request to the BSG operating service team. Your Ticket Number is " & recID,

{
Importance: "Normal",
IsHtml: true
}
);

// Notify the user and reset controls
Notify("Request added successfully.", NotificationType.Success);
Reset(txtdescription);
Reset(txtsubject);
Reset(Dropdown2);
Reset(TxtLead);
Reset(DataCardValue8_1);
Navigate(Screen1, ScreenTransition.Fade);

Default property of txtLead is 

Concatenate(
Concatenate(
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead.DisplayName,
" ,"
),
Concatenate(
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead2.DisplayName,
" ,"
),
Concatenate(
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead3.DisplayName,
" ,"
),
Concatenate(
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead4.DisplayName,
", "
),
LookUp(
'Ad-hoc team List',
Dropdown2.Selected.Value = Title
).Lead5.DisplayName
)

Best Regards,

Bhavith Shetty

[FLMike]

@BhavithShetty 

Thank you so much for sharing your code and Flow. One little detail. I am not sure what you are asking of us?

Are you asking us how to get the Email addresses for those same people?

Before we get to that, I notice that you have 6 names in the list (Lead textbox), but you only have code for 5, how are you showing 6 names in the Lead Text?

Are the Lead fields, lookups to users? or Text fields with the Display Name?

If its the LookUp, then I would suspect you could do .Select.Lead2.Email or PrimaryMail or whatever you are using for the Email address.

So essentially re-use the code you have for concatenating the stuff together, but instead get the right Email Address field and concat is using a ; (semi colon instead of a comma)

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[BhavithShetty]

Thanks for your reply FLMike. 

When the users click submit button. I would like an email notification to be sent to the multiple users in the Lead field. The Lead field is coming from a sharepoint list I have prefilled. The Lead field is concatenating 3-5 users I have identified in the sharepoint list.

In the code below, the monitor is giving me an error 

</>

Office365Outlook.SendEmail(
TxtLead, // Assuming TextInput1 contains the email address of the recipient
"[Ad-hoc Request]",
"Thank you for submitting a request to the BSG operating service team. Your Ticket Number is " & recID,

{
Importance: "Normal",
IsHtml: true
}
);

</>

[FLMike]

Hi @BhavithShetty 

I know why you are getting the error, its because you are just giving it a list of names separated by comma. Those are not email addresses.

You could not send an email like that in outlook or gmail etc, and you cannot do that here.

And you said 3-5 names but I see 6

My suggestion is, you store their email addresses in the SharePoint list and then when you are trying to send the email, use the Select.EmailAddress field (that you add) to get their email addresses and concat them all using a semicolon

Then use that value in your To list. and it will work.

That or you need to use the Office365Users connector to do a lookup against these names and get their email address that way.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[BhavithShetty]

Thank for your reply @FLMike ,

Lead in my sharepoint list is Person column whereas title is department value

here is the code 

Office365Outlook.SendEmail(
Concatenate(
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead.Email,
";",
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead2.Email,
";",
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead3.Email,
";",
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead4.Email,
";",
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead5.Email
),
"[Ad-hoc Request]",
"Thank you for submitting a request to the BSG operating service team. Your Ticket Number is " & recID,
{
Importance: "Normal",
IsHtml: true
}
);

Best Regards,

Bhavith Shetty

[FLMike]

Hi @BhavithShetty 

Yes that is what I asked before if they were lookups to users (People).

Ok now that you did what I said, is there an error still? or issue?

Can you show me the actual error if there is one please

If there isnt and it solved your issue I'd be grateful if you marked my answer is the answer/resolved and maybe a thumbs up.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[BhavithShetty]

Many Thanks for your reply @FLMike ,

I am still getting the error, i have attached screenshot . 

Best Regards,

Bhavith shetty

[FLMike · Accepted solution]

@BhavithShetty 

This means one or more of the Email Addresses for the people are not valid.

Please follow these instructions

1. Add a Text Label to the screen

2. In the Text property place your expression

Concatenate(
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead.Email,
";",
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead2.Email,
";",
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead3.Email,
";",
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead4.Email,
";",
LookUp('Ad-hoc team List', Dropdown2.Selected.Value = Title).Lead5.Email
)

3. Make sure you have selected your dropdowns etc before hand.

Once you have done that.

Please show me a picture of the ENTIRE output, meaning please make your label very large so it will show all the email addresses.

The issue is there.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey 

[BhavithShetty]

Many thank for the reply @FLMike 

i am publish the email ids of the Lead Name 

I have attached the screenshot for the same 

Best Regards,

Bhavith shetty

[FLMike]

Hi,

@BhavithShetty  please remove the extra ; at the end also you may want to update your image, the Created by has your email

Here is what I would like you to do.

Take all those emails and copy and paste them in outlook and make sure they work.

After you remove the extra ; at the end it should work.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey