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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Submitting form to sha...
Power Apps
Unanswered

Submitting form to sharepoint question

(1) ShareShare
ReportReport
Posted on by 6
I am a beginner to powerapps and am trying to create an app for internal use at work.
 
To give an overview of what I need to build, it is a form (which could technically be one form) however it needs to be filled in firstly by one person, then filled in by another person, so was thinking two forms within the app, on two screens. However, can i build it so that it saves and submits data at the end of screen one and then also does the same at the end of screen 2 and they update to the SAME row in the data source sharepoint file?
 
So on submitting form 1 certain columns have data passed to the sharepoint form, then on submitting form 2 the blanks are filled in on the other columns on the same row. Or would it automatically create  a new row for the second lot of data?
 
Appreciate some advice on if this is possible, if it makes sense or even best way to approach this if there is a better way - but please bare in mind I am a beginner so need to be quite a basic solution!
 
Thanks in advance
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,315 Super User 2025 Season 2 on at
     
    So this takes some thought.
     
    1. When you say form are you talking about a SharePoint form? Or are you talking about building a Small Canvas App?
     
    2. Also, it's possible to do this with the Following
    SharePoint List
    Microsoft Form / SharePoint Form or Canvas App
     
    3. Users create a Record
    NOTE :(The Microsoft Form example is slightly different, in that you'd have to grab the data with power Automate, first and then save it to SharePoint, versus the SharePoint form and or Canvas App that writes directly to the table, instead of Power Automate).
     
    All have the pros and cons.
    The Form/Screen would only show the Writeable Fields and any read-Only fields you want the user to see for information purposes
     
    Once the record is written to the SharePoint list, it can trigger a Power Automate flow, that could generate a link to another SharePoint Form, that is only setup to show the next set of writeable data and read-only parts, or the same Canvas App and email that to the second user (as well as CC you if you wanted to monitoring). 
     
    * If its the same canvas app, you would have 2 screens. 1 for user 1 and 1 for user 2.
    * You would simply pass in a couple of parameters to the Canvas App, so that when it triggers it would essentially go "oh this is a new record and show person 1 screen", or it would say "oh its item X and user 2 show that screen" and any variations of "re-update for user 1 or user 2 versus a new record etc" but you get the drift it would look like this.
     
     
    In the App.Onstart it would read the user and itemid and then find the correct record in SharePoint list and also show the proper screen
     
    4. So when the second person clicks the link, it opens the proper record and they can fill out only what you want and done.
     
    You could even have a secondary flow(or even the primary) that triggers when an item is created OR modified, so that you could capture tracking information to say both people are done with item321 now let people know (email whatever), set a Completed DateTime etc.
     
    And yes you can make it one record.
     
    You didn't mention anything about the 2nd person approving person one, but the original power automate could generate an approval for the second person, who could approve first, then be sent a link to update the rest of the record. It would just be a few extra actions in your power automate flow.
  • Suggested answer
    Hellen ramos Profile Picture
    12 on at
    Hello,
    It will be necessary to separate the filling out into two forms, and when you save form 1, in the OnSuccess property of the form 1 you must insert a variable recording the content of the line and use it as the item to be edited in the next form.
    See below:
     
     
    After submitting the first form, the second one will be available for editing, see below:
     
     
    I'm attaching a video showing how this will work.
     
    I hope this helps.
     
    Best regards.
     
     
     
  • Michael E. Gernaey Profile Picture
    53,315 Super User 2025 Season 2 on at
     
    Its 2 different people, so showing a second form on the same screen to the first person wouldn't make sense, that is why I said its 2 screens simply for Role based execution, not a single screen with 2 forms that just show up for the same person.
  • Hellen ramos Profile Picture
    12 on at
    @Michael, I created both forms on the same screen for example purposes only. The forms can be on two different screens and the variable will work the same way. From what I understand from the question, they are two different people but they will fill out the form at the same time.
    If it is at different times, just put a variable on the edit record button in a gallery or table.
    If you think of something different, feel free to suggest it. Thanks for the feedback.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 793 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 333 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard