Forum Discussion
Adding additional information to Microsoft Forms
- Sep 10, 2020
Hi Kathleen KBarrett2 , Forms is only part of the solution to your scenario. It's good for the initial incident report but you can't later go back into the form and add additional information. Forms doesn't have that functionality.
What we do in my company is to use a flow in Power Automate to pick up the form response and add it to a list in SharePoint. The same flow sends a confirmation email back to the submitter with the details of what they submitted and also, if necessary, sends an email to the person who needs to know that a new form has arrived.
Then whenever additional information needs to be added this is done in the SharePoint list, usually with a customised form in Power Apps as that allows you to do more than the default SharePoint form.
The advantage of using SharePoint is that it gives you an audit trail of everything that's been done on each item, you can have several people adding information into the form if you need to and it's a more robust solution that just using Forms or the spreadsheet behind the form.
I'm about to go into a meeting so won't post them up now, but if you want to see screenshots of how this all works (and it does work very well) just let me know.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Hi Kathleen KBarrett2 , Forms is only part of the solution to your scenario. It's good for the initial incident report but you can't later go back into the form and add additional information. Forms doesn't have that functionality.
What we do in my company is to use a flow in Power Automate to pick up the form response and add it to a list in SharePoint. The same flow sends a confirmation email back to the submitter with the details of what they submitted and also, if necessary, sends an email to the person who needs to know that a new form has arrived.
Then whenever additional information needs to be added this is done in the SharePoint list, usually with a customised form in Power Apps as that allows you to do more than the default SharePoint form.
The advantage of using SharePoint is that it gives you an audit trail of everything that's been done on each item, you can have several people adding information into the form if you need to and it's a more robust solution that just using Forms or the spreadsheet behind the form.
I'm about to go into a meeting so won't post them up now, but if you want to see screenshots of how this all works (and it does work very well) just let me know.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Thanks for your reply RobElliott
Using SharePoint and Power Apps sounds like a good solution to my problem. I will greatly appreciate if you could update me with the screenshots on how to do this. That would be wonderful as I was unable to replicate this myself.