Unanswered

How i can remove all list items attachments when submitting a form

(1) Share

Report

Posted on by johnjohnPter

2,074 Season of Giving Solutions 2025

I have a SharePoint form which have attachments. now I want to remove all the attachments that are already saved to SharePoint and only add new attachments added to the form when submitting the form. is there a way to achieve this?

thanks

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Pro_User_365 546 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @johnjohnPter ,
Before submitting the form, loop through the existing attachments using the ForAll function along with RemoveIf to delete them from the SharePoint list item.
Add the new attachments by collecting them in a temporary collection and then submitting them with the form

// To clear existing attachments ForAll(Gallery1.AllItems, RemoveIf(Attachments, ID = Parent.Default.ID)); // To add new attachments // Assume you have collected new attachments in a collection called 'colNewAttachments' ForAll(colNewAttachments, AddAttachment(SharePointListName, ID, FileName, FileContent));

Note: After receiving the answer, if you think it's helpful, please consider accepting it. 😊 Regards! Ali Shahzad
johnjohnPter 2,074 Season of Giving Solutions 2025 on at

Like
a
(1)

Report
Copy link

Link copied!

@Pro_User_365 this will remove them from sharepoint, but when we submit the form again all the attached (old and new ) will get resubmitted? correcT?

Also what is Attachments variable? and how i need to initiate it?
Pro_User_365 546 on at

Like
a
(0)

Report
Copy link

Link copied!
@johnjohnPter ,
Use ClearCollect to save the current attachments into a collection.
Use ForAll combined with RemoveIf to remove attachments from SharePoint.
Clear the attachment control to prevent re-submitting old attachments.
Add new attachments from your temporary collection to SharePoint.
Example:
// Save current attachments to a collection ClearCollect(colCurrentAttachments, YourFormName.Attachments); // Remove attachments from SharePoint ForAll(colCurrentAttachments, RemoveIf(Attachments, ID = Parent.Default.ID)); // Clear the attachment control Clear(YourFormName.Attachments); // Add new attachments to SharePoint ForAll(colNewAttachments, AddAttachment(SharePointListName, ID, FileName, FileContent)); // Submit the form SubmitForm(YourFormName);
By doing this, you ensure that only the new attachments are included when you submit your form.
johnjohnPter 2,074 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!
@Pro_User_365 have you tried what you have posted? as they do not make sense to me.. as
ClearCollect(colCurrentAttachments, YourFormName.Attachments);
will contain both the new and the old attachments...
Also what should the colNewAttachments contain??
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @johnjohnPter,

Please check this thread:

Solved: Removing files from attachment control - Power Platform Community (microsoft.com)