Answered

Patch Attachments to Sharepoint List

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I'm trying to add attachments from a peninput and also an attachment control into a sharepoint list, i'm trying to avoid having to use power automate as i'd rather everything was in powerapps for ease. Everything with my code is working perfectly apart from getting the attachments into the sharepoint list along with the rest of the data being captured and sent to the list. I've seen that when using patch, you can use a Lookup to get the attachments in but i've no idea where to put it, have you any ideas please?

ClearCollect(
colImages,
AddColumns(
RenameColumns(
AttachmentControl.Attachments,
"Value",
"ContentBytes"
),
"@odata.type",
""
),
{
Name: "Signature.jpg",
ContentBytes: Signature.Image
}
);

Office365Outlook.SendEmailV2("installation@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>

Survey Complete?: "&ValueSurveyStatus&" 
Customer: "&Customer.Text&" 
Address: "&Address.Text&" 
Job Number: "&'Job Number'&" 
Surveyor: "&Surveyor.Text&" 
Date: "&Date.SelectedDate&"

Door Ref: "&'Door Ref'&"

Existing Door to Remove: "&ValueExistingDoorToRemove&" 
Existing Access Control, Alarm etc: "&ValueExistingAccessControl&" 
S/O Substrate: "&'S/O Substrate'&" 
Cavity Closer Plates Required: "&ValueCavityCloser&" 
Recommended Steel Trim: "&ValueSteelTrim&" 
Ancillary Items: "&Ancillary&" 
Door Location on Site: "&'Door Location'&" 
Clear Access Route: "&ValueClearAccess&" 
Team Size: "&'Team Size'&" 
Additional Site Equipment: "&'Additional Site Equipment'&" 
Onsite Parking: "&ValueOnsiteParking&"

Notes: "&Notes&"

Regards

IT Department ",
{Attachments: colImages}
);
Reset(AttachmentControl);
Reset(Signature)
;
Patch(DoorSurvey, Defaults(DoorSurvey),
{
SurveyStatus: ValueSurveyStatus.Text,
Title: ValueDateTimeNow.Text,
Customer: Customer.Text,
'Site Address': Address.Text,
'Job Number': 'Job Number'.Text,
Surveyor: Surveyor.Text,
Date: Date.SelectedDate,
'Door Ref': 'Door Ref'.Text,
'Existing Door to Remove': ValueExistingDoorToRemove.Text,
'Existing Access Control, Alarm etc': ValueExistingAccessControl.Text,
'S/O Substrate': 'S/O Substrate'.Text,
'Cavity Closer Plates Required': ValueCavityCloser.Text,
'Recommended Steel Trim': ValueSteelTrim.Text,
'Ancillary Items': Ancillary.Text,
'Door Location on Site': 'Door Location'.Text,
'Clear Access Route': ValueClearAccess.Text,
'Team Size': 'Team Size'.Text,
'Additional Site Equipment': 'Additional Site Equipment'.Text,
'Onsite Parking': ValueOnsiteParking.Text,
Notes: Notes.Text
});
Navigate(Success,Cover)

Categories:

Connecting to Data

General Questions

All responses (2)

Answers (1)

Suggested answer

TimMiles 6 on at

Like (0)

Report

Patch Attachments to Sharepoint List

I was able to patch directly to a sharepoint list attachment field using the following. Note the first part captures a screenshot using the PDF control and stores it in appres://blobmanager. Then using the table format below in patch, it patches it to the sharepoint list. I havent tried multiple items yet, or how to patch into an attachment field that already has attachments. But this does work

//Capture screenshot

Set(VarEmployeeSignedDocument, PDF(Testing));

//Patch screenshot to attachments field

Patch(AisleAuditTransactions,Defaults(AisleAuditTransactions),

  {

Title:" Test",

Attachments:Table(

  {

DisplayName: "TestAttachScreenshot.pdf" ,

AbsoluteUri: Blank() ,

Id: VarEmployeeSignedDocument,

Value: VarEmployeeSignedDocument

  })

  });

Notify("Success", NotificationType.Success,1500);
Verified answer

v-bofeng-msft on at

Like (0)

Report

Re: Patch Attachments to Sharepoint List

Hi @Dave-ITMan ,

If you want to patch/Update the the attachments file to your SP list individually using Patch/Update function, I afraid that there is no way to achieve your needs in PowerApps currently.

As an alternative solution, you need to consider your Edit form data as a Whole, and type it within your Patch/Update formula. I have made a test on my side, please take a try with the following workaround:

1\Create an edit form(Form1) and set it's data source

2\edit fileds(Leave only the attachments field)

3\Modify the update if formula:

UpdateIf(Table1,true,Form1.Updates)

The Result:

I think this link will help you a lot:
Saving attachments using Patch

Best Regards,

Bof