Forum Discussion
Dylan_Wilson
Jun 07, 2022Copper Contributor
Flag a form as approved / rejected and then completed
Hi, I am new to MS Forms so any help would be welcome. I have created a form that anyone within the company can complete and an email is sent to myself and a colleague stating that a new response h...
- Jun 07, 2022
Dylan_Wilson you can't do this with just Forms, it is a basic Forms app that has no concept of "status". What we do for our IT Ticketing System at my company is that the user completes a form in Forms. That is picked up by a flow in Power Automate that saves the details into a SharePoint list and the flow sends a confirmation email back to the user with details of what they submitted and a reference number. One of the columns in that list is a Choice column for the status which will inititally be have a status of Open but of course once the work has been completed can then be changed to Completed. So the form should only be used for the initital submission and everything thereafter can be done in the SharePoint list.
Come back with any questions about this.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott
Jun 07, 2022Silver Contributor
Dylan_Wilson you can't do this with just Forms, it is a basic Forms app that has no concept of "status". What we do for our IT Ticketing System at my company is that the user completes a form in Forms. That is picked up by a flow in Power Automate that saves the details into a SharePoint list and the flow sends a confirmation email back to the user with details of what they submitted and a reference number. One of the columns in that list is a Choice column for the status which will inititally be have a status of Open but of course once the work has been completed can then be changed to Completed. So the form should only be used for the initital submission and everything thereafter can be done in the SharePoint list.
Come back with any questions about this.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
- Dylan_WilsonJun 07, 2022Copper Contributor
RobElliott - Thank you Rob. That's a a great help. I'll look into Power Automate and SharePoint and learn a bit more about them. Both your advice pointing me in the right direction and your offer of further assistance are very much appreciated.
All the best,
Dylan