Send Attachment from Sharepoint in Email

[jteddick]

Hi everyone!

I'm working with PowerApps to make a registration app. I am attempting to send a confirmation email once a user has registered with a calendar attachment (.ics file) that was uploaded in a Sharepoint list. But it is giving me the errors seen in the screenshot below. 

I even tried doing the commands seen below, but I still got the same issue.

ClearCollect(FinalAttachments, {Name: Available_Trainings.Selected.Attachments.DisplayName, ContentBytes: Available_Trainings.Selected.Attachments.Value, '@odata.type':""});

Office365Outlook.SendEmailV2("email@site.com", "Test", "Hi", {Attachments: FinalAttachments})

Any ideas what I am doing wrong?

Thank you!

[v-xida-msft · Accepted solution]

Hi @jteddick ,

Do you want to send an email to the specific user along with attachments stored in your SP List?

Regarding the formula that you mentioned, I think there is something wrong with it. I have made a test on my side, please try the following workaround:

Office365Outlook.SendEmail(
                            "user@email.com", 
                            "Test Email Subject Line", 
                            "Test Email", 
                            {
                                Attachments: ForAll(
                                                    ThisItem.Attachments As LoopRecord,
                                                    {
                                                        Name: LoopRecord.DisplayName,
                                                        ContentBytes: LoopRecord.Value,
                                                        '@odata.type': ""
                                                    }
                                ) 
                            }
)

On your side, please modify your formula as below:

Office365Outlook.SendEmailV2(
                             "email@site.com", 
                             "Test", 
                              "Hi", 
                             {
                                Attachments: ForAll(
                                                    Available_Trainings.Selected.Attachments As LoopRecord,
                                                    {
                                                        Name: LoopRecord.DisplayName,
                                                        ContentBytes: LoopRecord.Value,
                                                        '@odata.type': ""
                                                    }
                                              ) 
                             }
)

Please try above solution, then check if the issue is solved.

Regards,