Is it possible to use Patch Function to patch the attachment files into SharePoint?

[lliu_western]

Hello Community,

I have a form App - I do not use the EditForm function or having the PowerApps to create the Form for me. I built the entire form from scratch, where each individual dropdown box, input box or combo box are connected to SharePoint List/column one by one and the Submit button of the form, I use the "Patch" function. 

Is there anyways I can use patch function with the submit button I made to patch all the information along with the attachments into the SharePoint? 

Any advice is appreciated, thank you in advance.

[SanshubhLubal]

I created a Form and storing form's value in Collection then Showing Collection Values in Gallery. On Button Click I'm trying to Patch data of That Gallery.

Also there is Attachment column in that Form.

help me to Solve it @Westly  - ‎07-21-2022 10:09 AM

It's Solved. 10-02-2023 11:02 AM

[Bhanes22]

This is by far the easiest method I've found, super simple using flow - https://youtu.be/yC0W5am6M3Q

[HEATFreight]

How can I do this directly in a canvas app without using Power Automate? Is that possible?

I want to copy the attachments from an item in list A to an existing item in a totally different list, call it list B. It does not seem like PowerApps allows for programmatically copying attachments between items in different SharePoint lists. Can someone confirm if this is true?

See my response in this other thread.

[HEATFreight]

Aha! I figured it out. If you need to patch attachments from an item in one SharePoint list to an item in a totally different SharePoint list, you must first remove the Attachments.Id parameter from the collection!

I used the following code:

ClearCollect(colAttachments,AddColumns(DropColumns(colAttachments,"Id"),"Id",""));
ResetForm(AttachmentsForm);
Patch(SharePointList,LookUp(SharePointList,ID=ThisItem.ID),AttachmentsForm.Updates);

[HEATFreight]

Aha! I figured it out how to patch attachments from an item in one list to an item in a DIFFERENT list without using flow. If you need to patch attachments from an item in one SharePoint list to an item in a totally different SharePoint list, you must first remove the Attachments.Id parameter from the collection!

I used the following code:

ClearCollect(colAttachments,AddColumns(DropColumns(colAttachments,"Id"),"Id",""));
ResetForm(AttachmentsForm);
Patch(SharePointList,LookUp(SharePointList,ID=ThisItem.ID),AttachmentsForm.Updates);

[Power2Power]

Patch do not support updating the Attachments table within each record... but UpdateIf does!  In the condition to locate the active ID you can use a lookup with conditions that pull the ID. In the items to update in the curly brackets now  you can call Attachments and update it w/ a table that has the same defaults. 

[HEATFreight]

Yes it does. You have to use: 

Patch(SharePointList,{ID:varID},AttachmentsForm.Updates)

[HEATFreight]

UpdateIf is not delegable: click here

[Power2Power]

Thanks, I'll keep this in mind. I used UpdateIf in an attachment component, so not using the form control (and it is non-delegable like @HEATFreight mentioned). 

[ankit12]

You can use Update function instead of Patch to save attachments