Unanswered

How to save existing Attachments using SubmitForm (New)?

(0) Share

Report

Posted on by HappyPotato

Hello,

I have a project that requires me to copy an existing and completed record with attachments and submit it as new Request, means the existing old attachments must be included also.

I was able to solve the problem by using New Form instead of Edit form but having a problem with the attachments.

I was not able to save the existing attachments to the new record; If I added new attachments and it will only save the new attachments to the new record not the old existing once.

I tried using a separate form for attachment and used this code

Patch(Database, ThisRecord.LastSubmit, Form.Update);

But it is still not working.

My question is how can I save the old existing attachments when I copy the old record to re-submit them as new?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 152,827 Most Valuable Professional on at

Like (0)

Report
How to save existing Attachments using SubmitForm (New)?

Hi @HappyPotato,

Put this OnSuccess of the first form
Patch( Database, LookUp( Database, ID = Self.LastSubmit.ID ), YourFormName.Updates );

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Power Platform 1919 1,773 on at

Like (0)

Report

How to save existing Attachments using SubmitForm (New)?

Hi @HappyPotato,

To create a new record with patch function,

Use this formula format:

Patch(Datasource,Default(Datasource),Form.LastSubmit)

Was this reply helpful? Yes No
HappyPotato 14 on at

Like (0)

Report

How to save existing Attachments using SubmitForm (New)?

Hi @WarrenBelz and @Power Platform 1919,

Thanks for the responses,

I have already tried your solutions, but unfortunately, they are not working if the attachments are already existing, they would work only if they attached new attachments and the only items that will be saved are the new once not the existing one.

The solution that I came up is to integrate the Power Automate.

Was this reply helpful? Yes No