Forum Discussion
Wanderlust
Dec 03, 2019Copper Contributor
Gathering Forms into folders in Sharepoint & analysis per folder
Hello hello! I need to create a form that gathers feedback on each workshop that was held. For this I want to create a question with a drop-down list which contains pre-defined list of answers. ...
RobElliott
Dec 03, 2019Silver Contributor
Wanderlust it wouldn't be folders but you could could save the responses to SharePoint to different lists based on the workshop attended. You'd need to use Power Automate (Flow) and after the Forms trigger and Get response details you'd have a Switch control with the condition based on the workshop attended. If the workshop was Public Speaking then the flow would be to add a SharePoint Create item action to the Public Speaking list. If the workshop was something else, e.g. Communications , then the flow action in that case would be to create an item in the Communications list.
You can't generate an analysis per list. You'd need to do that with Power Bi or something similar.
Rob
Los Gallardos
Microsoft Power Automate Community Super User