Answered

Submitting data from Power Apps to SharePoint list (multiple forms)

(0) Share

Report

Posted on by ET-04121333-0

Hi everyone,

I have a Power App survey consisting of some text input fields (including a v-look up), and 5 Forms. All fields are pulled from a SharePoint list.

At the end of each page is a "Next" button. On Select it navigates to the next page. Do I need to add anything else to the On Select property of the Next buttons?

At the end of the survey is a "Submit" button. Here I need help to write the Patch function which will send all data back to the SharePoint, please :)

Below is what I've got so far....I think I need to combine data but I'm sure how...

Thank you !!

 
// OnSelect of the button
Patch(
    'FY27 Enterprise Risk Assessment Survey',
    Defaults('FY27 Enterprise Risk Assessment Survey'),
    {
 
// Combine data from Form1
  
// Combine data from Form2
 
// Combine data from Form3
 
// Combine data from Form4
 
// Combine data from Form5
       
       // Additional fields
        Email: Email.Text,
        'Management Level': {
            Value: LookUp(Table1, Email = [@Email].Text, 'Management Level')
        }
    }
);
// Reset each form after submission
ResetForm(Form1);
ResetForm(Form2);
ResetForm(Form3);
ResetForm(Form4);
ResetForm(Form5);
 
// Navigate to the success screen
Navigate('Success', ScreenTransition.Fade);

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
Hi @ET-04121333-0,

Something like this - just ensure that you have not duplicated any fields across those forms, or subsequent entries will overwrite the previous ones.
Patch( 'FY27 Enterprise Risk Assessment Survey', Defaults('FY27 Enterprise Risk Assessment Survey'), Form1.Updates, Form2.Updates, Form3.Updates, Form4.Updates, Form5.Updates, { Email: Email.Text, 'Management Level': { Value: LookUp( Table1, Email = [@Email].Text, 'Management Level' ) } } ); ResetForm(Form1); ResetForm(Form2); ResetForm(Form3); ResetForm(Form4); ResetForm(Form5); Navigate( 'Success', ScreenTransition.Fade );

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 5,036 Super User 2025 Season 2 on at

Like (1)

Report

@ET-04121333-0,

Form.Updates only works if the form is properly connected to the same data source and has valid fields.

If Form1.Updates or any .Updates is empty or misconfigured, the Patch will silently fail or skip fields.

In that case, no other way you have to expand all the fields and patch

Patch(

'FY27 Enterprise Risk Assessment Survey',

Defaults('FY27 Enterprise Risk Assessment Survey'),

{

// From Form1

Title: DataCardValue1.Text, // Replace with actual control name

// From Form2

'Column': DataCardValue3.Text,

// From Form3

Column: DataCardValue4.Selected.Value,

// From Form4

Column: DataCardValue5.Text,

// From Form5

'Column': DataCardValue6.Selected.Value,

// Additional fields not in the forms

Email: Email.Text,

'Management Level': {

Value: LookUp(Table1, Email = Email.Text, 'Management Level')

}

}

);

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
ET-04121333-0 26 on at

Like (0)

Report

Thank you both!

@MS.Ragavendar , do you think I can get around the issue you described in the following way?

If(

Form1.Valid && Form2.Valid && Form3.Valid && Form4.Valid,

Patch(

'FY27 Enterprise Risk Assessment Survey',

Defaults('FY27 Enterprise Risk Assessment Survey'),

Form1.Updates,

Form2.Updates,

Form3.Updates,

Form4.Updates

);

ResetForm(Form1); ResetForm(Form2); ResetForm(Form3); ResetForm(Form4);

Navigate(Success, ScreenTransition.Fade),

Notify("Please complete all required fields", NotificationType.Error)

)

Was this reply helpful? Yes No
MS.Ragavendar 5,036 Super User 2025 Season 2 on at

Like (0)

Report

@ET-04121333-0,

It will works with your check but everything is connected to same datasource?

Was this reply helpful? Yes No