Email with attachments office365V2

(0) Share

Report

Posted on by K369

216

Hi all,

I have this code working well:

Office365Outlook.SendEmailV2("myname@misite.com","Subject-"&DataCardValue11_2.Selected.Value&"-"&DataCardValue12_2.Text,"Sub2-:-"&DataCardValue11_2.Selected.Value&""&" "&" "&"DATE-:-"&DataCardValue10_2.SelectedDate&""&" "&""&" "&"Sub3-:-"& DataCardValue12_2.Text&""&" "&""&" "&"Sub4-:-"& DataCardValue13_2.Text &""&" "&""&" Sub5----:"& DataCardValue14_2.Text &""&" "&""&" "&"Sub6-:-"& DataCardValue15_2.Text &""&" "&" "&"Sub7-:-"& DataCardValue16_2.Text&""&" "&" "&""&"Sub7"&""&" "&User().FullName) &""&" "&"{Attachments:AddColumns(RenameColumns(EmlAtt.Attachments ,"&" "Value" "&" ContentBytes")&""& "@odata.type"&""& "")})

Now I want to include attachment bit and code is in RED , but gives me errors and can't figure out what am I doing wrong...

Please help...

PS: EmlAtt is the attachment control

Categories:

Building Power Apps

All responses (8)

Answers (2)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @K369

Office365Outlook.SendEmailV2( "stalin@ltiblogs.onmicrosoft.com", "Test", "Test Body", { Attachments: AddColumns( RenameColumns( DataCardValue9.Attachments, "Value", "ContentBytes" ), "@odata.types", "" ), Importance: "Normal" } );
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @K369

I tested with & and <be> and all works fine. Please format the code one by one and we can validate the error.
Office365Outlook.SendEmailV2( EmailAddressDataCard.Text, "Subject-" & PNCard.Text & "-" & "DataCardValue12_2.Text", DataCardValue10.Text & " " & "This should be next line", { Attachments: AddColumns( RenameColumns( DataCardValue9.Attachments, "Value", "ContentBytes" ), "@odata.types", "" ), Importance: "Normal" } );
K369 216 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks StalinPonnusamy
That's true. The code given by you will work in its simple form.
However with bit of I really don't know how to proceed after FullName in my code. Please help
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @K369

Looks issue after the .FullName. Please try this
Office365Outlook.SendEmailV2("myname@misite.com","Subject-"&DataCardValue11_2.Selected.Value&"-"&DataCardValue12_2.Text,"Sub2-:-"&DataCardValue11_2.Selected.Value&""&" "&" "&"DATE-:-"&DataCardValue10_2.SelectedDate&""&" "&""&" "&"Sub3-:-"& DataCardValue12_2.Text&""&" "&""&" "&"Sub4-:-"& DataCardValue13_2.Text &""&" "&""&" Sub5----:"& DataCardValue14_2.Text &""&" "&""&" "&"Sub6-:-"& DataCardValue15_2.Text &""&" "&" "&"Sub7-:-"& DataCardValue16_2.Text&""&" "&" "&""&"Sub7"&""&" "&User().FullName, { Attachments: AddColumns( RenameColumns( DataCardValue9.Attachments, "Value", "ContentBytes" ), "@odata.types", "" ), Importance: "Normal" } )
K369 216 on at

Like
a
(0)

Report
Copy link

Link copied!

User().FullName) , {Attachments
The comma in red is the only error it shows now with remarks " Unexpected characters. Characters are used in the formula in an unexpected way."
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @K369

In the below code, Just only change to your email and try it.
Office365Outlook.SendEmailV2( "stalin@ltiblogs.onmicrosoft.com", "Subject-" & "DataCardValue11_2.Selected.Value" & "-" & "DataCardValue12_2.Text", "Sub2-:-" & "DataCardValue11_2.Selected.Value" & "" & " " & " " & "DATE-:-" & "DataCardValue10_2.SelectedDate" & "" & " " & "" & " " & "Sub3-:-" & "DataCardValue12_2.Text" & "" & " " & "" & " " & "Sub4-:-" & "DataCardValue13_2.Text" & "" & " " & "" & " Sub5----:" & "DataCardValue14_2.Text" & "" & " " & "" & " " & "Sub6-:-" & "DataCardValue15_2.Text" & "" & " " & " " & "Sub7-:-" & "DataCardValue16_2.Text" & "" & " " & " " & "" & "Sub7" & "" & " " & User().FullName, { Attachments: AddColumns( RenameColumns( EmlAtt.Attachments, "Value", "ContentBytes" ), "@odata.types", "" ), Importance: "Normal" } )
And we will replace datacard value later
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @K369

For the above, here is the email
Verified answer

K369 216 on at

Like
a
(0)

Report
Copy link

Link copied!

The issue is still the same. Thank you very much taking time to help me.
The moment I get ) after FullName all the errors go away but , Comma after that is in red. Let me try again