Remove last letter from Concat and send mail with attachment not working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have two issues below that I am trying to resolve. Any helps would be appreciated.

1. I used the formula below to concat the filenames of attachments, but I would like to remove the & at the end.

Concat(DataCardValue57.Attachments,Name & " & ")

2. I use the formula below to send email with attachments but is not working. The error message is "Invalid number of arguments: Received 5, expected 3-4"

Office365Outlook.SendEmailV2( To1_2.Text, Subject1_2.Text,RichTextEditor1, {Cc: CC1_2.Text}, {Attachments: AddColumns(RenameColumns(DataCardValue57.Attachments,"Value","ContentBytes"),"@0data.type","")})

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

Plz try this formulas it may help you

Formula 1:

Concat( LastN( DataCardValue57.Attachments,
CountRows(DataCardValue57.Attachments) - 1 ), Name, ", " ) &
Last(DataCardValue57.Attachments).Name

Formula 2:

Office365Outlook.SendEmailV2( To1_2.Text, Subject1_2.Text, RichTextEditor1.HtmlText,
{Attachments: AddColumns(RenameColumns
(DataCardValue57.Attachments,"Value","ContentBytes"),
"@odata.type","")} )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

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

Like (0)

Report
Copy link

Link copied!

Thanks for the response but unfortunately i encountered errors below

1. The value returns duplicate last attachment filenames.

2. I added the formula and the error is gone but it seems the formula exclude the CC. Is there a way to include CC in it?

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

1.To avoid duplicate last attachment filenames, you can use the Distinct function.

2.
Office365Outlook.SendEmailV2(
{
To: To1_2.Text,
Cc: CC1_2.Text,
Subject: Subject1_2.Text,
Body: RichTextEditor1.Text,
Attachments: AddColumns(
RenameColumns(
DataCardValue57.Attachments,
"Value",
"ContentBytes"
),
"@odata.type",
""
)
}
)

Thanks!

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

Like (0)

Report
Copy link

Link copied!

Thanks but I get the error below

1. The formula below does not grab the first attached file name and instead duplicates the filename of second attached file. So I am not sure how distinct will work on this.

2. I get the error below for the revised forumulas

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

Like (0)

Report
Copy link

Link copied!

I used the formula below and it grabs all the filenames without duplicates

Concat(LastN( DataCardValue57.Attachments,CountRows(DataCardValue57.Attachments) +1 ), Name, ", " )

Was this reply helpful? Yes No