Unanswered

Powerapps form won't save changes - App has multiple screens with the same data

(0) Share

Report

Posted on by vlp24 Microsoft Employee

Hi! I'm trying to create an app that has 3 screens all pulling in SharePoint data. While editing the form, any changes made revert back when clicking save.

OnSave formula:

SubmitForm('General Info Form'); SubmitForm(File); SubmitForm('Feedback 1');SubmitForm('File Setup Form'); SubmitForm('Feedback Review Form')

Do I need to add any additional formulas on the forms Items?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

MarcelLehmann 378 on at

Like (0)

Report
Copy link

Link copied!

You could try just OnSave
SubmitForm('General Info Form')
And put the others of each form before on the OnSuccess 😉

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @vlp24,

Do you want to submit multi forms to generate a single record in your SharePoint List?

Could you please share a bit more about your scenario?

To save multi forms to generate a single record, you need to use Patch():

Patch(ListName, <here is the fomrula you set for Item property of each Form>, 'General Info Form'.Updates, File.Updates, 'Feedback 1'.Updates, 'File Setup Form'.Updates, 'Feedback Review Form'.Updates )

Note that the above formula is to edit an existing record, you should specific a special record in each form.

Generally, we will have a Gallery to display all the records and once you select one record in Gallery, it could navigate you to the form, where you could edit the Gallery selected record. In this situation, we set the Item property of each form as:

Gallery.Selected

Was this reply helpful? Yes No
vlp24 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

So the 3 screens that I have 1 is for Triage, 2 is for Feedback and 3 is for Review. I was able to add a submit button on screens 1 and 3, which allowed me to save changes accept for I have the State field on all 3 screens, this field reverts back whenever I click save or submit on screen 1. Hopefully that clarifies a little more. Also the form is defaulted to open on the Feedback Form tab.

I did try the Patch function and then got an error on my form not allowing me to save.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @vlp24,

I think the key to this issue maybe the unmatched data type.

Could you please tell me that:

1). how you set the Items property and the DefaultSelectedItems property of the Status dropdown?(IMPORTANT)

2). is the status column a Choice type?

3). You just need to save the form in the screen1 and screen3, right?

Was this reply helpful? Yes No
vlp24 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
1)
Items: Filter(Choices([@'CO+I Localization Feedback Form'].'Feedback State'), Value="Review Completed") * This differs for each screen on what it's filtered to
DefaultSelectedItems: Parent.Default
2) Yes, it's a choice column
3) I need it to save on all 3 screens

Was this reply helpful? Yes No