SOLVED

Microsoft Forms Combability / Functionality Enquiry

Copper Contributor

Hi all,

 

My employer is looking for a specific software solution, and I was tasked with finding out if  Microsoft Forms will support some of the functions we require, and as I'm completely new Forms, and I managed to find some answers online already, but still have few left. Would anyone be able to support me on any of the below please it will be a massive help. 

QuestionYes/NoComment
Workflow includes dashboard and alerting for aged forms  
Automated date and time stammped on the form and included in log file for all chnages and updates  
Solution includes basic built in document management and storage ( classification, retention status)   
Where LOGICS is not system...Ability to store captured data in a secure repository/database that is hosted by ITS  
Legal/certified E Signature (Sign on glass not accepted in court)  
Device agnostic   
Audit trail/ escalation /approval / history  
Ability export to PDF  
Forms to include spellchecker MMM  
Solution intgrates with Document Management solution   
Access to completed forms can be restricted by user gorups / Data classification   
Form can be classified as Confidential, Restricted , Internal use   
License model based on etiehr Device based or Enterprise wide (NFR)   
Alert for form can create an automated alert based on type of forms and data entered    
allows data to be pulled from other systems in to the form - M  
Integrated into LOGICs  
Alwasy up based solutrion ( NFR)  
Photo Analysis (Data science)  
incldues workflow option to allow automated reviews, approval etc. - M  
A form can create an automated alert based on type of forms and data entered  - M  
Ability to upload Office documents to create a form  - M  
Solutuion includes basic on screen reporting - C  
Ability to create a schedule for users  
Forms designer inbuilt in  the solution to create new forms - M  
2 Replies
best response confirmed by misiek5510 (Copper Contributor)
Solution

@misiek5510 Microsoft Forms is a very simple package and cannot handle most of your questions. To make more use of it than the out-of-the-box features you will need to learn Power Automate  where you can then do saving into SharePoint, SQLServer etc, do approvals and so on.

 

QuestionYes/NoComment
Workflow includes dashboard and alerting for aged formsNoThere is no dashboard and workflow for Microsoft Forms. And using Power Automate will not give details about aged forms unles you save the details of each form into SharePoint list.
Automated date and time stammped on the form and included in log file for all chnages and updatesNoForm responses are timestamped, but unless there is something in the Office 365 Admin Centre, there is no log of changes.
Solution includes basic built in document management and storage ( classification, retention status) NoDocuments uploaded in a form are saved to OneDrive or SharePoint, but there are no specific document management features or anything to do with retention, that would have to be set in SharePoint
Where LOGICS is not system...Ability to store captured data in a secure repository/database that is hosted by ITSYesA flow in Power Automate can save responses to a massive number of apps and software.
Legal/certified E Signature (Sign on glass not accepted in court)NoThere is nothing like this in Forms.
Device agnostic YesWorks on desktop, tablet, mobile
Audit trail/ escalation /approval / historyYesProviding you build a flow in Power Automate, each response can be routed for approval, saved to SharePoint with approval status etc 
Ability export to PDFYesIndividual reponses can be saved to PDF. Additionally a flow in Power Automate can create a PDF of each response.
Forms to include spellchecker MMMNoNot available
Solution intgrates with Document Management solution YesBut only by building a flow in Power Automate
Access to completed forms can be restricted by user gorups / Data classification YesA user or group needs to be given the Share to Collaborate link and can then can view responses and edit the form.
Form can be classified as Confidential, Restricted , Internal use NoThere is no functionality for this
License model based on etiehr Device based or Enterprise wide (NFR) NoNot available
Alert for form can create an automated alert based on type of forms and data entered  YesBut only by building a flow in Power Automate
allows data to be pulled from other systems in to the form - MNoInformation in a form cannot be brought in from another application or pre-populated
Integrated into LOGICsNoForms cannot be embedded, you will only get a link to to the form.
Alwasy up based solutrion ( NFR)NoDepends on Microsoft
Photo Analysis (Data science)NoNot available
incldues workflow option to allow automated reviews, approval etc. - MNoYou would need to build this in a flow in Power Automate
A form can create an automated alert based on type of forms and data entered  - MYesBut only by building a flow in Power Automate
Ability to upload Office documents to create a form  - MNoThere is no automation or api for creating a form
Solutuion includes basic on screen reporting - CNoNot available
Ability to create a schedule for usersNoNot available
Forms designer inbuilt in  the solution to create new forms - MYes 

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

 

Thank you very much. I really appreciate it.
1 best response

Accepted Solutions
best response confirmed by misiek5510 (Copper Contributor)
Solution

@misiek5510 Microsoft Forms is a very simple package and cannot handle most of your questions. To make more use of it than the out-of-the-box features you will need to learn Power Automate  where you can then do saving into SharePoint, SQLServer etc, do approvals and so on.

 

QuestionYes/NoComment
Workflow includes dashboard and alerting for aged formsNoThere is no dashboard and workflow for Microsoft Forms. And using Power Automate will not give details about aged forms unles you save the details of each form into SharePoint list.
Automated date and time stammped on the form and included in log file for all chnages and updatesNoForm responses are timestamped, but unless there is something in the Office 365 Admin Centre, there is no log of changes.
Solution includes basic built in document management and storage ( classification, retention status) NoDocuments uploaded in a form are saved to OneDrive or SharePoint, but there are no specific document management features or anything to do with retention, that would have to be set in SharePoint
Where LOGICS is not system...Ability to store captured data in a secure repository/database that is hosted by ITSYesA flow in Power Automate can save responses to a massive number of apps and software.
Legal/certified E Signature (Sign on glass not accepted in court)NoThere is nothing like this in Forms.
Device agnostic YesWorks on desktop, tablet, mobile
Audit trail/ escalation /approval / historyYesProviding you build a flow in Power Automate, each response can be routed for approval, saved to SharePoint with approval status etc 
Ability export to PDFYesIndividual reponses can be saved to PDF. Additionally a flow in Power Automate can create a PDF of each response.
Forms to include spellchecker MMMNoNot available
Solution intgrates with Document Management solution YesBut only by building a flow in Power Automate
Access to completed forms can be restricted by user gorups / Data classification YesA user or group needs to be given the Share to Collaborate link and can then can view responses and edit the form.
Form can be classified as Confidential, Restricted , Internal use NoThere is no functionality for this
License model based on etiehr Device based or Enterprise wide (NFR) NoNot available
Alert for form can create an automated alert based on type of forms and data entered  YesBut only by building a flow in Power Automate
allows data to be pulled from other systems in to the form - MNoInformation in a form cannot be brought in from another application or pre-populated
Integrated into LOGICsNoForms cannot be embedded, you will only get a link to to the form.
Alwasy up based solutrion ( NFR)NoDepends on Microsoft
Photo Analysis (Data science)NoNot available
incldues workflow option to allow automated reviews, approval etc. - MNoYou would need to build this in a flow in Power Automate
A form can create an automated alert based on type of forms and data entered  - MYesBut only by building a flow in Power Automate
Ability to upload Office documents to create a form  - MNoThere is no automation or api for creating a form
Solutuion includes basic on screen reporting - CNoNot available
Ability to create a schedule for usersNoNot available
Forms designer inbuilt in  the solution to create new forms - MYes 

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

 

View solution in original post