Unanswered

HOW TO SAVE MULTIPLE EDIT FORMS AS ONE ENTRY

(0) Share

Report

Posted on by stayclassy

Hello everyone.

I have a problem with saving entries into a table.
Namely, my table has many mandatory and optional fields, and it has a Unique ID column - which only arises after the new entry is saved in Table.

To save a new entry, in my application, I use Edit Forms, but not just one, BUT SEVERAL OF THEM arranged in different containers. Each Edit Form contains a certain number of Data Cards that must be filled in (because they are mandatory) before clicking the "Save entry" button.

Formulas such as: Submit Form(Edit Form 1); Submit Form(Edit Form 2); Submit Form(Edit Form 3); and so on are not considered because each time an attempt is made to create a new entry, which is not possible (I only fill in certain fields in each form). Also, I must keep in mind that each entry must be possible to EDIT AGAIN in the App later and save it as the same entry and not as a NEW one.

Any kind of help is welcome. Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

iClarkSi 117 on at

Like (0)

Report

Hey @stayclassy ,

I hope you are well.

I don't know if this works for you, but it is possible to make the field validation on the UI and not on the List.

This would solve you problem of not being able to use SubmitForm() and you would still need to fill certain fields on the app in order to proceed.

Was this reply helpful? Yes No
IamnotBob 51 on at

Like (1)

Report

Are you able to not use forms? Create individual fields in a container. Then use Patch() to add to the DataSource or update the DataSource as you need to with just the fields you need.
Patch function (contains video) - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
stayclassy 44 on at

Like (0)

Report

How exactly do you mean? Do you have any examples or videos?

Was this reply helpful? Yes No
Verified answer

BhaskarDhone 1,392 Super User 2025 Season 2 on at

Like (1)

Report
Try this for creating a record with multiple forms.

Patch( 'Sample Tables', Defaults('Sample Tables'), Form2.Updates, Form2_1.Updates, Form2_2.Updates );
Same goes for update as well

Patch( 'Sample Tables', LookUp( 'Sample Tables', ID = "23" ), Form2.Updates, Form2_1.Updates, Form2_2.Updates );

Was this reply helpful? Yes No
iClarkSi 117 on at

Like (0)

Report
@stayclassy ,

To make a validation through UI, you would need:

Make the mandatory fields become optional
Create rules for each field on you powerapp through PowerFX
About using muliple Form controls, you don't need to. You can do it like @IamnotBob said or you can actually just customize your Form control to display the fields dynamically.

I cannot make an example right now, but if you don't find an answer for your issue till later today, I'll post here again.

This is a really good video because he explains these both validation methods: How to validate power apps edit form before submit - YouTube

Was this reply helpful? Yes No
IamnotBob 51 on at

Like (0)

Report

There are quite a few resources out there using Patch(). Just use the Patch() function to write the info you wish to save.
7 Ways To Use The PATCH Function In Power Apps (Cheat Sheet) (matthewdevaney.com)

(Shane Young) I believe this one will also show you how to get the new record added which you can save in a collection or variable for later.
Saving Power Apps Data with the Patch Function (youtube.com)
(Reza Dorrani) Power Apps PATCH function Tutorial with Modern Controls (youtube.com)
and How to use PATCH Function in Power Apps | Insert and Update data (youtube.com)

Was this reply helpful? Yes No
IamnotBob 51 on at

Like (0)

Report

@BhaskarDhone this approach should work as well. Have you ever had issues with duplicate saved entries?
Reza touches this @ about 28 minutes in (2) How to use PATCH Function in Power Apps | Insert and Update data - YouTube

Was this reply helpful? Yes No
stayclassy 44 on at

Like (0)

Report

@BhaskarDhone Thank you for your help. Do you perhaps have an idea on how to obtain a Unique ID at the moment of saving a new entry for the above mentioned example (each EditForm contains mandatory fields)? The thing is, I save multiple forms as one entry using the Patch function, and afterwards (I mean by clicking), I call a Flow in which the Unique ID is a required parameter for that entry.

Was this reply helpful? Yes No