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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How do I submit multip...
Power Apps
Unanswered

How do I submit multiple editforms data to same single sharepoint list

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I have 3 screen with three different editforms, but I separate my sharepoint list columns data in those three editforms. Now I want to update the sharepoint list as somebody submit the forms to those sharepoint list columns. I already tried Patch() function, But nothing good comes. Need more clarification on this, I will sharing some screen shorts for more clarification to see what I am actually asking. ax.PNG

 

As you can see from the image I have submitted the Editform1 first and thosedata will appread on sharpoint site, then I go to other screen and attached file for the same project no and project name, the submission would not make any changes to sharepoint site. So , I want to do this with multiple screen to updatet he single sharepoint list according to the choosen rows/data and update my sharepoint list data when required. The main reason to build mutiple screen is why the app and other screen are used by different peoples to they change make their changes as they see fit. 

Categories:
  • v-xida-msft Profile Picture
    Microsoft Employee on at

    HI @Anonymous ,

    Could you please share a bit more about your scenario?

    Do you want to submit your EditForm1 data firstly, and then go to other screens to make changes to the previous submitted record in Edit form1?

    Further, could you please share a bit more about the formula you typed within the Item proeprty of the EditForm1_1 and EditForm1_2?

     

    If you want to submit your EditForm1 data firstly, and then go to other screens to make changes to the previous submitted record in Edit form1, I have made a test on my side, please take a try with the following workaround:

    Within EditScreen1, set the OnSelect property of the "Submit" button to following:

    SubmitForm(EditForm1)

    Set the OnSuccess proeprty of the EditForm1 to following:

    Set(CurrentSubmitted, EditForm1.LastSubmit)

    Set the OnSelect proeprty of the "Navigate" button to following:

    EditForm(EditForm1_1);
    Navigate(EditScreen1_1, ScreenTransition.Fade)

     

    Within the EditScreen1_1, set the Item property of the EditForm1_1 to following:

    CurrentSubmitted /* <-- Set to the previous record submitted in your EditForm1 */

    Set DataSource property of EditForm1_1 to same SP list data source as your EditForm1.

    Set the OnSelect property of the "Submit" button to following:

    SubmitForm(EditForm1_1)

    Set the OnSelect property of the "Navigate" button to following:

    EditForm(EditForm1_2);
    Navigate(EditScreen1_2, ScreenTransition.Fade)

     

    Within the EditScreen1_2, set the Item property of the EditForm1_2 to following:

    CurrentSubmitted /* <-- Set to previous record submitted in your EditForm1 */

    Set the OnSelect property of the "Submit" button to following:

    SubmitForm(EditForm1_2)

    Set DataSource property of EditForm1_2 to same SP list data source as your EditForm1.

    Please take a try with above solution I provided, then check if the issue is solved.

     

    In addition, actually, it is not necessary to submit your EditForm1 data firstly, and then submit other Forms data. On your side, you could consider submit multiple forms data into your SP list data source once time.

    Please check and see if my response within the following threads would help in your scenario:

    https://powerusers.microsoft.com/t5/General-Discussion/Is-it-possible-to-split-the-Edit-Form-into-multiple-screens/m-p/243130

    https://powerusers.microsoft.com/t5/Creating-Apps/Multiple-forms-to-one-item-sharepoint-list/m-p/142893/highlight/true#M3783

    On your side, you could take a try with following workaround:

    Within EditScreen1, set the OnSelect proeprty of the "Navigate" button to following:

    NewForm(EditForm1_1);
    Navigate(EditScreen1_1, ScreenTransition.Fade)

     

    Within the EditScreen1_1, set DataSource property of EditForm1_1 to same SP list data source as your EditForm1.

    Set the OnSelect proeprty of the "Navigate" button to following:

    NewForm(EditForm1_2);
    Navigate(EditScreen1_2, ScreenTransition.Fade)

     

    Within the EditScreen1_2, set the OnSelect property of the "Submit" button to following:

    Patch(
    'YourSPList',
    Defaults('YourSPList'),
    EditForm1.Updates,
    EditForm1_1.Updates,
    EditForm1_2.Updates
    )

    Set DataSource property of EditForm1_2 to same SP list data source as your EditForm1.

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Its not working, I tried both the ways, but its not working for me, I do exactly the same and every step , but it still don't work, Its only saing the data in first column, which is our main fixed column. If you could share more information or show case any short video, then let me see, how its working for you. 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I have tested with Patch(), the function suits the workability, But its not working, Its not updating the updating the data in other columns, It only updating only in first clumn, by adding new item, but not in other columns. I would be interested to know how should my simple text data goto the Sharepoint list of other columns with the follow up data by that I submitted in other screen. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 339 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 289

#3
Mohsin Ali Profile Picture

Mohsin Ali 228

Last 30 days Overall leaderboard