Outlook email works but gmail does not.

[Corissandageri]

Hello

I had great success having a preformatted email that I can send with Outlook but when I change my connector from Outlook to Gmail and my expression from Office365Outlook.SendEmail to Gmail.SendEmail I instantly get the invalid argument error. I have searched the net but not really come up with anything.

Thank you

[SeanHenderson]

Hi @Corissandageri 

Did you change the format of your email formula? For Gmail you need something like:

Gmail.SendEmailV2("emailaddress@email.com", {Subject: "Test", Body: "Body Test"})

---
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."

[Corissandageri]

Yes I changed it from:

Office365Outlook.SendEmail(Dropdown_Email.Selected.Result, "This weeks order P.O "& OrderNumber,"Hello "& Char(32)& Dropdown2_3.Selected.Result & Char(10)& CanIPlease &Char(10) & Concat(Purchaselist2,"Qty: " & OrderQty12 & Char(32)&"Code: " & Codes12 & Char(32) & "Description: " & Description12 & Char(10))& Char(10)& TextInputTotal & Char(10) & Char(10)& Notes1)

To:

Gmail.SendEmailV2(Dropdown_Email.Selected.Result, "This weeks order P.O "& OrderNumber,"Hello "& Char(32)& Dropdown2_3.Selected.Result & Char(10)& CanIPlease &Char(10) & Concat(Purchaselist2,"Qty: " & OrderQty12 & Char(32)&"Code: " & Codes12 & Char(32) & "Description: " & Description12 & Char(10))& Char(10)& TextInputTotal & Char(10) & Char(10)& Notes1)

As a side note, Char(10) does not seem to work with Office365Outlook.SendEmailV2

[v-xida-msft]

Hi @Corissandageri ,

Based on the Gmail.SendEmailV2(...) formula that you mentioned, I think there is something wrong with it.

The standard formula syntax of Gmail.SendEmailV2(...) function as below:

Gmail.SendEmailV2(To, {Cc: Text, Subject:Text, Body: Text, importance:Text, Attachments: Table})

So on your side, please consider modify your formula as below:

Gmail.SendEmailV2(
                  Dropdown_Email.Selected.Result,
                  {
                    Subject: "This weeks order P.O "& OrderNumber,
                    Body: "Hello "& Char(32)& Dropdown2_3.Selected.Result & Char(10)& CanIPlease &Char(10) & Concat(Purchaselist2,"Qty: " & OrderQty12 & Char(32)&"Code: " & Codes12 & Char(32) & "Description: " & Description12 & Char(10))& Char(10)& TextInputTotal & Char(10) & Char(10)& Notes1
                  }
)

Please consider take a try with above solution, check if the issue is solved.

Best regards,

[Corissandageri]

Thank you, it is now sending, but just one more thing. With outlook I got the correct format like this:

Hello 
Can I please order
Qty: 1 Code: 10396 Description: Checkmate 400ml
Qty: 1 Code: 10069 Description: Degresol 201 20L
Qty: 1 Code: 3460 Description: Hand Guard 20L

Total Ex GST & freight $674.49

But now the Char(10) does not seem to work and the email comes through like this:

Hello Rons Can I please order Qty: 1 Code: 10396 Description: Checkmate 400ml Qty: 1 Code: 10069 Description: Degresol 201 20L Qty: 1 Code: 10422 Description: H.T.H Granules Qty: 1 Code: 3460 Description: Hand Guard 20L Qty: 1 Code: 7300442 Description: Kwiksan 22 1000L Qty: 1 Code: 7300441 Description: Kwiksan 22 200L Qty: 1 Code: EA R200032 Description: PAA & PEROXYACETIC TEST KIT Qty: 1 Code: R100242 Description: R100242 Hydrion Test paper QC1001 Qty: 1 Code: 3192 Description: Sanicol 10L Qty: 1 Code: 3292 Description: Top Active DES 20L Qty: 1 Code: 7300339 Description: Topax 545 200L Qty: 1 Code: 7300446 Description: Topax 545 20L Qty: 1 Code: 7302468 Description: Tsunami 200L Qty: 1 Code: 7302467 Description: Tsunami 25KG Qty: 1 Code: 2648 Description: Turbochlor 1000L Qty: 1 Code: 10305 Description: Turbochlor 200L Qty: 1 Code: 5971 Description: Windex 20L Qty: 1 Code: 4610 Description: XY12 200L Total Ex GST & freight $10336.33

[v-xida-msft · Accepted solution]

Hi @Corissandageri ,

Based on the issue that you mentioned, I have made a test on my side, and the issue is confirmed on my side. It seems that the Char(10) function is not supported within Gmail body.

As an alternative solution, please consider replace the Char(10) within your email body message with "<br/>", replace the Char(32) with " ". On your side, please consider modify your formula as below:

Gmail.SendEmailV2(
                  Dropdown_Email.Selected.Result,
                  {
                    Subject: "This weeks order P.O "& OrderNumber,
                    Body: "Hello <br/>"& Dropdown2_3.Selected.Result & "<br/>" & Can I Please & "<br/>" & Concat(Purchaselist2, "Qty: " & OrderQty12 & " " &"Code: " & Codes12 & " " & "Description: " & Description12 & "<br/>")& "<br/>" & TextInputTotal & "<br/>" & "<br/>" & Notes1
                  }
)

If you would like the Char() function to be supported in Gmail body, please consider submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Best regards,

[Corissandageri]

Thank you again, it is now emailing and correctly formatted, probably 20 years since I last typed any html. I was expecting I would have to html the whole email for "<br/>" to work.