Unanswered

Adding Attachments to SharePoint List

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have the below code on a button via the OnSelect, can you tell me how I can add the attachments that the user uploads to my sharepoint list please? They are coming through via email fine but I can't get them into the sharepoint list, I need both the attachments and the signature:

ClearCollect(

colImages,

AddColumns(

RenameColumns(

AttachmentControl.Attachments,

"Value",

"ContentBytes"

"@odata.type",

{

Name: "Signature.jpg",

ContentBytes: Signature.Image

}

);

Office365Outlook.SendEmailV2("emailaddress@mydomainname.com" , 'Result Job Number'.Text , "Hi,

Please see completed survey form below and attached drawings

<a href=https://mydomainname.sharepoint.com/sites/PowerApps/Lists/DoorSurvey/AllItems.aspx>Click Here to View the Full SharePoint List</a>

Customer: "&Customer.Text&"

Address: "&Address.Text&"

Job Number: "&'Job Number'&"

Surveyor: "&Surveyor.Text&"

Date: "&Date.SelectedDate&"

Notes: "&Notes&"

Regards

IT Department ",

{Attachments: colImages}

);

Reset(AttachmentControl);

Reset(Signature)

;

Patch(DoorSurvey, Defaults(DoorSurvey),

{

Title: ValueDateTimeNow.Text,

Customer: Customer.Text,

'Site Address': Address.Text,

'Job Number': 'Job Number'.Text,

Surveyor: Surveyor.Text,

Date: Date.SelectedDate,

Notes: Notes.Text

});

Navigate(Success,Cover)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Dave-ITMan ,

I have a blog on various parts of this process that may be useful to you.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Dave-ITMan on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Thanks for the quick response, that's about emailing the attachments which i've done but i'm trying to get the attachments and the signature into a sharepoint list

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Dave-ITMan ,

You have lost me a bit there - you already have them on an Attachment control. What are you trying to add and how are you collecting it?

Was this reply helpful? Yes No
Dave-ITMan on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
So i'm collecting any images/files that are uploaded via an attachment control, there is also a peninput box for a signature which is being collected using the below code. What i'm trying to do is get all of those images/files and also the signature to upload to my sharepoint list in the attachments area of the record with the results from what they've filled out in the form. Hopefully this makes more sense
ClearCollect(
   colImages,
   AddColumns(
      RenameColumns(
          AttachmentControl.Attachments,
          "Value",
          "ContentBytes"
      ),
      "@odata.type",
       ""
   ),
   {
      Name: "Signature.jpg",
      ContentBytes: Signature.Image
   }
);

Was this reply helpful? Yes No
Dave-ITMan on at

Like
a
(0)

Report
Copy link

Link copied!

I'm also using patch to get the results into my sharepoint list if that helps?

{Attachments: colImages}
);
Reset(AttachmentControl);
Reset(Signature)
;
Patch(DoorSurvey, Defaults(DoorSurvey),
{
Title: ValueDateTimeNow.Text,
Customer: Customer.Text,
'Site Address': Address.Text,
'Job Number': 'Job Number'.Text,
Surveyor: Surveyor.Text,
Date: Date.SelectedDate,
Notes: Notes.Text
});

Was this reply helpful? Yes No
WarrenBelz 156,064 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Dave-ITMan ,

Using the same principle as in my blog, except this is not an easy one after that and involves sending the collection to Power Automate and creating an Array Variable from it. You might post this on the Power Automate Community.

Was this reply helpful? Yes No