Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

problem with submitform and navigate using sharepoint list

(0) ShareShare
ReportReport
Posted on by

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:
  • Community Power Platform Member Profile Picture
    on at
    Re: problem with submitform and navigate using sharepoint list

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

    Odeslaný screenshot obrázekOdeslaný screenshot obrázekOdeslaný screenshot obrázekOdeslaný screenshot obrázek

     

    And when I edit I use SubmitForm:

     

    Odeslaný screenshot obrázekOdeslaný screenshot obrázekOdeslaný screenshot obrázekOdeslaný screenshot obrázek

     

    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. 

  • v-xida-msft Profile Picture
    on at
    Re: problem with submitform and navigate using sharepoint list

    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

  • Community Power Platform Member Profile Picture
    on at
    Re: problem with submitform and navigate using sharepoint list

    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.

  • Community Power Platform Member Profile Picture
    on at
    Re: problem with submitform and navigate using sharepoint list

    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.

  • v-xida-msft Profile Picture
    on at
    Re: problem with submitform and navigate using sharepoint list

    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:Test1.gif

     

     

    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😞9.JPG

     

    10.JPG

     

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard