web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : lc4kYT0KHzr5+7OTv4Amx4
Power Apps - Building Power Apps
Unanswered

Data validation on selecting submit button...

Like (0) ShareShare
ReportReport
Posted on 29 May 2018 14:06:13 by

Dear Power users,

 

I've created an App using a database from a Sharepoint list, and this App contains multiple pages.

Each page corresponds to a specific section of the list (General informations, Quality, Security, ... etc).

I duplicated my "FormNewCase" from the first page to each page (the name changes by FormNewCase_1, FormNewCase_2, ... etc) and I selected questions from the right section.

On each page, I've inserted a "next" button with the following command :

[action, on select:]  Navigate(Quality, ScreenTransition.Fade)   => to go to the Quality section

 

 On the last one I've inserted a "record" button to validate data in my Sharepoint list with the following command :

[action, on select :] SubmitForm(FormNewCase)

 

When I click on the record button data are not saved on my sharepoint list ! 😕

 

What do I forget ?

 

Thank you in advance for your support...

  • Community Power Platform Member Profile Picture
    on 12 Jun 2018 at 14:07:23
    Re: Data validation on selecting submit button...

    OK guys, I solved my issues.

    Everything works well now.

    Thank you for your support.

  • Community Power Platform Member Profile Picture
    on 07 Jun 2018 at 13:51:34
    Re: Data validation on selecting submit button...

    Hi all,

     

    In order to start on a good base, I created a new Sharepoint list.

    What I've done is to test step by step and see what works and doesn't work.

     

    1- If I submit only the first page (FormNewCase), with the following script : on select=SubmitForm(FormNewCase) on the button "next" => data in my sharepoint list are recorded.

     

    2- If I submit The two first pages (FormNewCase and FormNewCase_1), with the following script : on select=SubmitForm(FormNewCase); SubmitForm(FormNewCase_1) on the button "next" => data from the FormNewCase are recorded in the sharepoint list but not data from FormNewCase_1.

     

     

     

     

     

  • Community Power Platform Member Profile Picture
    on 01 Jun 2018 at 14:36:52
    Re: Data validation on selecting submit button...

    Hello Kris and sorry to answer lately.

     

    So about the "next button" that's what I have done.

    About the "record button", when I click on it the app stays on the last page and my record doesn't work. 😕

  • v-xida-msft Profile Picture
    on 01 Jun 2018 at 09:19:07
    Re: Data validation on selecting submit button...

    Hi @Anonymous,

     

    Could you please show a bit more about your SharePoint list?

     

    When you save data from your PowerApps app to your SharePoint list using Submit() function, you must make sure all required fields of your SP list are filled with value. In addition, the Submit() function only take effect on only one EditForm once time. 

     

    If you use Submit(FormNewCase) formula within OnSelect property of Button control in the last page (Screen), this function could only submit form data within your first screen.

     

    I assume that you have three Screens (Pages) within your PowerApps app, I have made a test on my side and please take a try with the following workaround:

    • Set OnSelect property of the Next Button control within first Screen (Page) to following formula:
    Navigate(Screen2,ScreenTransition.Fade)
    • Set OnSelect property of the Next Button control within second Screen (Page) to the following formula:
    Navigate(Screen3,ScreenTransition.Fade)
    • Set OnSelect property of the Record button control within last Screen (Page) to following formula:
    Patch(StudentInfo,Defaults(StudentInfo),FormNewCase.Updates,FormNewCase_2.Updates,FormNewCase_3.Updates)

    Note: The StudentInfo is a SharePoint list datasource within my PowerApps app. On your side, you should type the following formula within OnSelect property of the Record Button control:

    Patch(YourSharePointListDatasource,Defaults(YourSharePointListDatasource),FormNewCase.Updates,FormNewCase_2.Updates,FormNewCase_3.Updates,...,FormNewCase_n.Updates)

     

    Best regards,

    Kris

  • bdodu Profile Picture
    399 on 30 May 2018 at 15:14:49
    Re: Data validation on selecting submit button...

    May be this helps you as well:

     

    https://powerusers.microsoft.com/t5/General-Discussion/Sharepoint-List-record-update-FROM-powerapps-collection-or/td-p/32585

  • bdodu Profile Picture
    399 on 30 May 2018 at 14:33:38
    Re: Data validation on selecting submit button...

    so you are sure you did bind all the forms to the same datasource and same record (may be gallery.selected)

    Update property of each datacard is set to the right control

    and onFailure of form2 and 3 is not triggered ?

     

    Did you try to save only one form? let's say form2 with an additional temporary button trigger the Submit for form2.

    If it is not updating sharepoint list than you need to check all the mentioned properties.

  • Community Power Platform Member Profile Picture
    on 30 May 2018 at 13:19:25
    Re: Data validation on selecting submit button...

    I'm back... So I made the modification and I don't have error but on my sharepoint list I have only the first part record (FormNewCase and not the others)

  • Community Power Platform Member Profile Picture
    on 30 May 2018 at 13:09:21
    Re: Data validation on selecting submit button...

    Many thanks for your quick answer... I'm going to check and come back ASAP...

  • bdodu Profile Picture
    399 on 30 May 2018 at 13:06:49
    Re: Data validation on selecting submit button...

    Ok I get it now.

    You basically have not one but 3 forms.

    When you press the button you submit actually only one form which is by the name the first one.

    You should submit all of them by writhing another 2 commands after the first submit:

     

    OnSelect = SubmitForm(FormNewCase); Submit(FormNewCase_2);Submit(FormNewCase_3)

     

     

  • Community Power Platform Member Profile Picture
    on 30 May 2018 at 12:58:39
    Re: Data validation on selecting submit button...

    You will find below some screenshot of what I did.

    Database informationsDatabase informationsinformation of the databaseinformation of the databasevalidation buttonvalidation button

     

     

     

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete