Unanswered

SP List Form with Multiple Screens, Data not Saving Correctly to The List

(0) Share

Report

Posted on by Thomasjruss

Hello!

I have a Power Apps customized SP list form with 3 screens. I've got a main screen with a choice data card in a form on it. At the bottom, there is a button that navigates to one of two other screens based on the selected value in the choice data. On that next screen, there is a single line of text data card, a back button that works fine, and a submit button with the following in the On Select Property:

SubmitForm(SharePointForm1);
SubmitForm(SharePointForm2);
Notify("Form Submitted", Success);
ResetForm(SharePointForm1);
ResetForm(SharePointForm2);
Navigate(FormScreen1,ScreenTransition.Fade)

When I click the button though, it will save the title appropriately, however the data from the second form (SharePointForm2 in this case), will only write to the first line in the list and will overwrite that data.

Of course, I want the data to all be written to the same list item.

Any help?

Best,

Thomas

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

TheRobRush 11,128 Moderator on at

Like (0)

Report

You will need to check that form 2 has datasource set to the datasource, and that its ITEM property is set to the specific item you want to edit

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (1)

Report

Hi @Thomasjruss ,

You need to have separate fields on the two forms as changes you have made on the first form will not be reflected on the second form, which will still have the original data and will therefore overwrite what you have changed. Simply remove from the second form any fields you are going to change on the first one OR remove the Update on the data cards on these fields on the second form.

Please click Accept as solution 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 giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Thomasjruss 46 on at

Like (0)

Report

@TheRobRush @WarrenBelz
This is the data source for the main (1st) page:

One of the branching screens (its the same for both) looks this way:

When I remove the update property functions, nothing gets written at all.
As you can see, none of the data cards overlap between screens.

Was this reply helpful? Yes No
Thomasjruss 46 on at

Like (0)

Report

@TheRobRush @WarrenBelz
Whoops, forgot this detail, the item property looks like this:
Would the issue have something to do with that First function?

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @Thomasjruss ,

I meant remove the Update only on cards that were duplicated on the second form. The Item would not affect this if you can see the correct record as that is what is being submitted.

What are the fields on both forms - you seem to have Question 1 on both.

Was this reply helpful? Yes No
Thomasjruss 46 on at

Like (0)

Report

@WarrenBelz

On SharePointForm1 there are:
Title
FHIP Work Product
Attachments

On SharePointForm2 there is:
Test Question 1

On EditForm3 there is:
Test Question 2

When I remove the Update formula, nothing gets written at all. When I have DataCardValue3.Text for instance, it saves to the 1st line.

Was this reply helpful? Yes No
Thomasjruss 46 on at

Like (0)

Report

What ended up needing to happen was, the form on the first screen needed to have the data fields on it of the other forms on the other two screens, and then the update property on the data cards on the main form set to the text of the duplicate data card on the other two forms. Then I hid the fields on the first form. The fields to have human input on the secondary forms should have their update properties cleared, as Warren said. What I've found, is that the only form that will actually save the list item correctly is the one on the first screen created with the app.

On the OnNew property for the SharePointIntegration, it is important to use a NewForm function for all of the screens with data fields, else the entire SharePoint List will need to be refreshed in between form submissions.

Thanks!

Was this reply helpful? Yes No