Forum Discussion
Flag a form as approved / rejected and then completed
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_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 - 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
