Unanswered

problem with submitform and navigate using sharepoint list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I am trying to create something like survey. Its not exactly survey it should be something like questions before your work trip what you should answer. I created share point lists and I created app. There is lot of questions so I dont want to have it on one screen but on 2 or 3 where you can complete fisrt screen go on another.Problem is with submirform I think. I dont know if its possible but I have in code something like SubmitForm(EditForm1);Navigate(EditScreen2,Cover) where I save the first screen so I submit form( so i submit first screen so half of the list) and then I continue to other screen but problem is that its save the first screen but i cannot get to another. I can add some screens here :

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you please share a bit more about your scenario?

Do you put lot of questions of one record (of your SP list) into multiple Edit forms within different screens?

I have made a test on my side and don't have the issue that you mentioned. The screenshot as below:

In addition, I don't think the SubmitForm function could achieve your needs. If you use SubmitForm function to submit data into your SP list, it would add a new record into your SP list when running this function each time.

In other words, when you run the SubmitForm function within your first Edit screen, it would add a new record into your SP list. When you run tlhe SubmitForm function within your second Edit screen, it would add another new record into your SP list rather than update the record the first SubmitForm function created.

As an alternative solution, please take a try to achieve your needs using Patch function. I have made a test on my side, please take a try with the following workaround (I assume that you have two Edit screens within your app😞

Set the OnSelect property of the "Navigate" button wirthin the first Edit screen (EditScreen1) to following formula;

Navigate(Screen2,ScreenTransition.None)

Set the OnSelect property of the "Submit" button within the second Edit screen (EditScrren2) to following formula:

Patch(
'20180712_case4',
Defaults('20180712_case4'),
Form1.Updates,
Form2.Updates
)

Note: The Form1 represents the Edit form control within the first Edit screen, the Form2 represents the Edit form control within the second Edit screen.

Please also check if the following thread would help in your scenario:

https://powerusers.microsoft.com/t5/General-Discussion/Multiple-form-submit-tried-patching-and-submit/td-p/75581

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I figured it out with submit forms but it has some problems when I want to create the new one form, so I will try Patch function and see if it will work. Thank you very much.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Ok so I tried Pach function but there is a little problem. When I am creating a new form its fine It will create and save. Problem is when I want to edit form I created before. It doesnt edit the one I want but It creates the new one from the old one and the old one is still there. I dont know where is the problem.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

How do you edit the record that you created before within your app?

Could you please share a bit more about the issue within your app?

I assume that you have two Edit screens (which contains two Edit forms -- Form1 and Form2) within your app, please make sure the OnSelect property of the Navigate button (Click it to edit the form/record) set to following formula:

Navigate(EditScreen1,ScreenTransition.Fade);EditForm(Form1);EditForm(Form2);

Set the Item property of the Form1 and Form2 to following formula:

BrowserGallery1.Selected

Note: The BrowserGallery1 represents the Gallery control within your Gallery screen.

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi I have something like this. When I want to create new data(new user data), I have 3 screens I use Patch function :

And when I edit I use SubmitForm:

My question is if I am using it right. Because something I lose my data and I am not sure if its good way how to store data.

Was this reply helpful? Yes No