Answered

Question about the SendEmail function?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a form with 7/8 data card values I wish to send by email. The Office365.SendEmail function only allows me to input 3 fields before an error is thrown. There must be a way of sending more than three data card values by email. I can't find this method, but if anyone has a link for the correct method online, could you send it to me?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

CarlosFigueira Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
The three (required) parameters of the SendEmail function are the e-mail recipient, e-mail subject and the body of the e-mail message. If you want to send information about multiple cards in an e-mail, you can compose the body of the e-mail using the Concatenate function or the '&' operator. The example below shows one example of that - the value returned by 'Char(10)' is a new line character, so the e-mail below has 4 lines in the body, from 4 different data cards.

Office365.SendEmail( "john@doe.com", "Many fields from form", "Title: " & DataCardValue1.Text & Char(10) & "First Name: " & DataCardValue2.Text & Char(10) & "Last Name: " & DataCardValue3.Text & Char(10) & "Birthday: " & DateValue1.SelectedDate)

Hope this helps!

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

Like
a
(0)

Report
Copy link

Link copied!

EDIT: I figured out formatting using IsHTML: true, I am yet to figure out how to send it to multiple email addresses from the same function. Any ideas on how to do this?

Thank you, this is exactly what I was looking for.

Is there a way to format this? The data card values are written next to each other in the email. Is there a way to tab each data card value?

Thanks for your help!

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Glad you figured out how to format the e-mail body using HTML. To send multiple e-mails, depending on the connector that you are using you can separate the recipients using semicolons:

Office365.SendEmail( "john@doe.com; jane@roe.com; jim@poe.com", "Many fields from form", "Title: " & DataCardValue1.Text & Char(10) & "First Name: " & DataCardValue2.Text & Char(10) & "Last Name: " & DataCardValue3.Text & Char(10) & "Birthday: " & DateValue1.SelectedDate)

You can find this information in the reference for the connectors - for example, here is the one for the Office 365 Outlook connector: https://docs.microsoft.com/en-us/connectors/office365/#actions

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

Like
a
(0)

Report
Copy link

Link copied!

Again, thank you for your help. This is all I needed.

Thank you!

Was this reply helpful? Yes No
jbachman 40 on at

Like
a
(0)

Report
Copy link

Link copied!

@CarlosFigueira- Is there a way to fill the To field by having the person type in an email address? I think your answer here might be the answer I am looking for on the post I just created here, but want to make sure that there is a way to have the user input the TO address rather than having it send to the same person every time.

Thanks!

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@jbachman yes, you can get the value for the first parameter to the SendEmail function from a control in your app, where a user would fill it in, like in the example below:

Office365.SendEmail( TextInputRecipient.Text, "Many fields from form", "Title: " & DataCardValue1.Text & Char(10) & "First Name: " & DataCardValue2.Text & Char(10) & "Last Name: " & DataCardValue3.Text & Char(10) & "Birthday: " & DateValue1.SelectedDate)

Was this reply helpful? Yes No