It depends; are the sections User A fills related to the sections User B fills? In other words, are User A’s answers required before User B can make decisions or complete their own section?
If both users’ answers are independent of each other, you can simply create the form in Power Apps and allow users to log in whenever they want and complete only the sections they are responsible for.
It will not be a fully “live” collaborative experience, meaning User B will not see User A typing responses in real time, and there will not be an indicator showing another user is currently working on the same form. However, users can still see updates made by others whenever the form refreshes. You can even add a Refresh button to force an immediate data refresh so newly saved responses become visible almost instantly.
On the other hand, if the answers from different users are dependent on each other, i.e., User A must complete their section before User B can proceed, then a step-by-step workflow would make more sense. In that scenario, each user can log in periodically, complete the sections assigned to them, and then the next user in the process can continue afterward.
If I were building something like this, assuming your data is stored in SharePoint, I would use Power Automate to handle this sequential process.
You would mainly need a mapping of who initiates the process and who comes next. This can be stored in a SharePoint list with columns such as Current User and Next User. For example:
- User B comes after User A
- User C comes after User B
Once that mapping is in place, you can create a Power Automate flow using the “When an item is added or modified” trigger. The flow can identify who modified the item, refer to the mapping list, determine the next responsible user, and automatically notify them that it is their turn to complete their section of the form.
Please let me know if you have any follow-up questions. Happy to help however I can.
Please ✅ 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 answering Yes to Was this reply helpful? or give it a Like! 🩷