Unanswered

EditForm remove attachments

(0) Share

Report

Posted on by Iantaylor2050

599

I have a powerapp newform with SharePoint as the datasource. User can upload documents in NewForm which gets stored in document library successfully. Below is the code for the same.

NewForm Submit Button

ForAll(
 DataCardValue11.Attachments As file,
 'UAT-UploadtoDocLib'.Run(
 {
 contentBytes: file.Value,
 name: file.Name
 },
 DataCardValue3.Text,
 DataCardValue15.Text
 )
 );

I tried the same in EditForm, where user can upload additional documents. Sample2 and Sample3 are the new docs attached in EditForm. If i delete Sample1.docx here in EditForm, it should get deleted from document library as well. May i know how to achieve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Hassan_SZ_365 542 on at

Like (0)

Report
Copy link

Link copied!
Hi @Iantaylor2050 ,

Here is a high-level approach to achieve this:
Maintain a collection of the original attachments when the form is opened. You can do this in the OnVisible property of the screen or OnEdit property of the form.
Compare the original attachments collection to the current attachments in the DataCardValue11.Attachments. Identify which attachments have been removed by the user.
Call a Power Automate flow to delete the removed attachments from the SharePoint document library.
Here's how you can structure the code in PowerApps and Power Automate:
PowerApps:
When the form is opened for editing, save the original attachments list:

ClearCollect(originalAttachments, DataCardValue11.Attachments);
On the save button or OnSuccess of the form, check for deletions and call the flow:
ForAll(originalAttachments, If( Not(file in DataCardValue11.Attachments), 'PowerAutomateFlowName'.Run(file.Name) ) );
Replace 'PowerAutomateFlowName' with the actual name of your flow.

Power Automate:
Create a flow triggered by PowerApps.
Add a SharePoint 'Delete file' action.
Use the identifier of the file or the file path from the PowerApps trigger data to specify which file to delete.
Remember, this is a high-level solution, and the actual implementation will require you to manage permissions and handle edge cases appropriately

Best Regards,
Hassan Raza

Was this reply helpful? Yes No
Iantaylor2050 599 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-qiaqi-msft

I tried getting the deleted documents from attachment control using above code. However the code is not working properly.

I need to send the deleted document name from attachments control to the flow. May i know how to achieve this?

Was this reply helpful? Yes No