I’ve been looking at Forms, SharePoint, and Flow to potentially provide a solution to a need we have:
I need to have multiple forms populate various fields in a SharePoint List record. Is something like this possible? Here’s the scenario:
Let’s say I have a SharePoint list with 12 fields. I would like to have the submission of Form #1 trigger the creation of a SharePoint list record. THis first form would have say, 5 fields leaving 7 unpopulated fields in the record. That much is very easy with Flow.
I would then I would like a notification to go to another person and present that person with Form #2 which would prompt for 4 fields and populate those in the SharePoint record created from Form #1. This leaves 2 fields left.
Then I would like a third person to receive a notice to fill out Form #3 which would populate the remaining 2 fields in original SharePoint List record.
Ideally, notifications for Form #2 and Form #3 would go out concurrently, and completed as the user is available.
Then, when all three forms are successfully submitted, a final notification goes back to the first user to approve the record.Â
I know this is rather complex, and likely outside the scope of Flow and Forms, but I thought I might give it a shot.
Suggestions?
Are you using Modern? Have you had thoughts about trying to use PowerApps for this? You could create the app for the list, and use different screens based on the stage you are in for adding records.
Hello, did you ever find a way to configure this? I’m trying to set up the same thing.