Mar 10 2021
02:31 AM
- last edited on
Aug 03 2023
08:14 PM
by
TechCommunityAP
Mar 10 2021
02:31 AM
- last edited on
Aug 03 2023
08:14 PM
by
TechCommunityAP
Hi everyone,
Each month, following our team meeting i send a survey out to get feedback. The questions are the same, and i leave it open for the same amount of time each month.
I wanted to know if there is a way of best managing this every month, as at the moment, i'm duplicating the form, and having to use a new form each month. I was hoping perhaps i could export the results, and then somehow clear out all responses and use that same form again? But i'm not sure if i'll lose anything by doing it this way?
I'm also having trouble with being able to save the forms in onedrive, any advise on that would be great.
Thanks,
Jodie
Mar 10 2021 05:46 AM
@jkearley I would suggest that you use a flow in Power Automate to save the results of the form into a list in SharePoint. You would only need 1 form for each month but by doing this you can filter the list to get each month's results. Out of the box it won't give you the nice pie charts and graphs that you get with Forms, but later on as your experience grows you can have a view of the list formatted with JSON to get those pie charts etc.
Saving the results of the form into a SharePoint list is not difficult and an example of how it's done is shown in the images below:
An alternative to SharePoint is to save the form responses into a table in an Excel spreadsheet which would give you more options for charts etc.
Come back with any questions about this.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Mar 10 2021 06:05 AM
Mar 11 2021 07:31 AM
Mar 16 2021 06:19 AM
Apr 09 2021 01:33 PM