Forward Outlook Attachments from PowerApps

(0) Share

Report

Posted on by rameshmukka

1,123

Hello Power Platform Experts,

I have a gallery connected to my Outlook inbox with below formula.

Office365Outlook.GetEmailsV3({folderPath: "Inbox", top: 25, fetchOnlyUnread:false, includeAttachments: true}).value

The only reason for taking this app is to form custom and standard subject line for project requirement. I am concatenating all below values to form subject line and appending it to original subject line from gallery. And then forward the gallery item to another mailbox with this newly formed custom subject line.

The only problem while am forwarding is that my attachments coming from gallery item not coming to my forwarded mailbox. Here is my formula in my OnSelect of Forward button. What is the mistake am doing here? I have tested by taking gallery item attachments to collection and it does show the attachments there. But they are not coming to my forwarded mailbox.

Office365Outlook.SendEmailV2(Dropdown1_5.Selected.Value,Label2.Text,Gallery1.Selected.body,{attachments:Gallery1.Selected.attachments})

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RameshMukka ,

Please try this formula:

Office365Outlook.SendEmailV2(Dropdown1_5.Selected.Value,Label2.Text,Gallery1.Selected.body,{attachments:RenameColumns(Gallery1.Selected.attachments,"contentBytes","ContentBytes","name","Name")})

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
rameshmukka 1,123 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft No, unfortunately that did not help. Have you test it and worked for you?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RameshMukka ，

Please try this:

1\ Set your gallery's onselect property to:

ClearCollect(Test,Gallery1.Selected.Attachments)

2\ Add a button control and set its onselect property to:

Office365Outlook.SendEmailV2(Dropdown1_5.Selected.Value,Label2.Text,Gallery1.Selected.body,{attachments:Test})

I did a test for you.

1\ This is my gallery control:

2\ Add a button control and set its Onselect property to:

Office365Outlook.SendEmailV2(User().Email,"TestB",Gallery1.Selected.Body,{Attachments:Test})

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
rameshmukka 1,123 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-xiaochen-msft Thank you for your detailed message. That doesn't worked for me unfortunately. Also I see yours is inline attachments. Am not worried about inline attachments.

Here is my email am trying to send. It has one inline attachment and other document attachment. I just masked the inline attachment.

Gallery items formula
If(RefreshOutlook,Blank(),Office365Outlook.GetEmailsV3({folderPath: "Inbox", top: 25, fetchOnlyUnread:false, includeAttachments: true, fetchOnlyFlagged:true,mailboxAddress:"1readytofiletmrcd@abc.com"}).value)

Gallery OnSelect formula
ClearCollect(colAttachments,Gallery1.Selected.attachments)

Button "Forward" OnSelect formula
Office365Outlook.SendEmailV2(Dropdown1_5.Selected.Value,Label2.Text,Gallery1.Selected.body,{attachments:colAttachments});

Here is what I receive after the click of the button. Both attachments are missing still.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RameshMukka ,

This seems to be an outlook setting/version problem, please check if this document can solve your problem.

Here

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
rameshmukka 1,123 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft I am not concerned about inline attachments. But the attachments like word document in my screenshot should be received right? Have you tried with such attachments in your example? I dont know what I am missing.

Was this reply helpful? Yes No
rameshmukka 1,123 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-xiaochen-msft Somehow SendEmailV2 was not working. I think the right function was to use ForwardEmailV2. Below formula worked with attachments too.

Office365Outlook.ForwardEmailV2(Gallery1.Selected.id,Dropdown1_5.Selected.Value,{mailboxAddress: "M365Flow@m365easysol.onmicrosoft.com"});
Thank you so much for all the help.

Was this reply helpful? Yes No
rameshmukka 1,123 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft That actually didn't solve my problem, Sorry! Though attachments are being forwarded, I dont have a way to insert my custom subject line am forming in my PowerApps. Anyway that you can help?

Was this reply helpful? Yes No
Verified answer

rameshmukka 1,123 on at

Like
a
(0)

Report
Copy link

Link copied!
Finally below formula has solve the problem for me

ClearCollect( colAttachments, AddColumns( DropColumns( RenameColumns( ThisItem.attachments, "name", "Name", "contentBytes", "ContentBytes" ), "contentId", "contentType", "id", "isInline", "lastModifiedDateTime", "size" ), "@odata.type", "" ) )

Was this reply helpful? Yes No