Office365.sendmail - new line

[giselisestari]

Created an app, and I would like to send more than one line in the body of the email. Can you do that?

Sorry for the english, I'm Brazilian so there may be some errors. 🙂

Office365.SendEmail('E-mail do Cliente_DataCard1'.Default; "Descrição do Atendimento" & 'Descrição Atendimento_DataCard2'.Default; "Nome do Cliente: " & 'Nome do Cliente_DataCard2'.Default & "Produto: " & Produto_DataCard2.Default;{Attachments:Table({Name:"Teste.jpg";ContentBytes:MyDoodles.Image;'@data.type':""})})

[JLockwood]

If you set IsHtml to true, then you can use break tags:

Office365.SendEmail(emailto, "Testing Linebreaks", "This is <br> <br> a test", {IsHtml: true})

[CarlosFigueira · Accepted solution]

Boa tarde 🙂

You can use the Char(10) expression, which represents a new line character, to split the message body in multiple lines, like in the example below:

Office365.SendEmail(
    'E-mail do Cliente_DataCard1'.Default;
    "Descrição do Atendimento: " & 'Descrição Atendimento_DataCard2'.Default;
    "Nome do Cliente: " & 'Nome do Cliente_DataCard2'.Default & Char(10) &
        "Produto: " & Produto_DataCard2.Default;
    {
        Attachments: Table(
            { Name: "Teste.jpg"; ContentBytes:MyDoodles.Image; '@odata.type':"" }
        )
    })

Another hint that I noticed - the Default property of the cards stores the initial values from the data source. If the user types something different in the text input controls, for example, the Default property will not be changed. You can use the Update property of the card, which should have the current version of the text input:

Office365.SendEmail(
    'E-mail do Cliente_DataCard1'.Update;
    "Descrição do Atendimento: " & 'Descrição Atendimento_DataCard2'.Update;
    "Nome do Cliente: " & 'Nome do Cliente_DataCard2'.Update & Char(10) &
        "Produto: " & Produto_DataCard2.Update;
    {
        Attachments: Table(
            { Name: "Teste.jpg"; ContentBytes:MyDoodles.Image; '@odata.type':"" }
        )
    })

Hope this helps!

[giselisestari]

Thank you worked out using char (10) and I followed your tip. PowerApps is a fascinating product. Thanks.

[giselisestari]

Thank you it worked, com o IsHTML.
Thanks.

[Anonymous]

Char(10) , Char(13) or both together , nothing working. OR it stopped working now.

[snipesnab]

It appears that with the new V2 Office365.sendmail connector the emails default to HMTL format which means that char(10) will no longer work. Instead use <br> to create a new line in your email.

e.g.

Office365Outlook.SendEmailV2(
"email@email.com",
"New Request",
Concat(
Request,
"Todays Date: " & Todays_Date & "<br><br> Requestor: " & Requestor & "<br> Urgency: " & "<br> Scope: " & Scope & "<br> Action By: " & CompleteBy & "<br> What is required: " & What & "<br> Why is this required: " & Why
)

[Thiago_G]

Worked like a charm @snipesnab , been searching all afternoon for this, thanks a lot mate!