Home

Gathering Forms into folders in Sharepoint & analysis per folder

%3CLINGO-SUB%20id%3D%22lingo-sub-1044104%22%20slang%3D%22en-US%22%3EGathering%20Forms%20into%20folders%20in%20Sharepoint%20%26amp%3B%20analysis%20per%20folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1044104%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20hello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20form%20that%20gathers%20feedback%20on%20each%20workshop%20that%20was%20held.%3C%2FP%3E%3CP%3EFor%20this%20I%26nbsp%3Bwant%20to%20create%20a%20question%20with%20a%20drop-down%20list%20which%20contains%20pre-defined%20list%26nbsp%3Bof%20answers.%20Each%20answer%20is%20equal%20to%20a%20different%20workshop%20that%20was%26nbsp%3Bheld.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20that%20this%20is%20already%20possible%20to%20do.%20What%20would%20be%20even%20more%20interesting%20to%26nbsp%3Bdo%26nbsp%3Bis%20to%26nbsp%3Breceive%20filled-in%20forms%26nbsp%3Binto%20folders%26nbsp%3Bwithin%20Sharepoint.%20Every%20folder%20would%20then%20contain%20only%20filled%20in%20forms%20concerning%26nbsp%3Ba%20particular%20workshop.%20For%20example%2C%20the%20folder%20called%20Public%20speaking%20would%20contain%20all%20filled-in%20forms%20concerning%20Public%20speaking%20workshop.%20Is%20it%20possible%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELast%20but%20not%20least%2C%20is%20it%20possible%20to%20generate%20analysis%20per%20created%20folder%3F%20Thus%2C%20I'd%20have%20analysis%20on%20every%20workshop%20that%20was%20held%20separately.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20loads%26nbsp%3Bfor%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEster%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1044104%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1044725%22%20slang%3D%22en-US%22%3ERe%3A%20Gathering%20Forms%20into%20folders%20in%20Sharepoint%20%26amp%3B%20analysis%20per%20folder%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1044725%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F476302%22%20target%3D%22_blank%22%3E%40Wanderlust%3C%2FA%3E%26nbsp%3B%20it%20wouldn't%20be%20folders%20but%20you%20could%20could%20save%20the%20responses%20to%20SharePoint%20to%20different%20lists%20based%20on%20the%20workshop%20attended.%20You'd%20need%20to%20use%20Power%20Automate%20(Flow)%20and%20after%20the%20Forms%20trigger%20and%20Get%20response%20details%20you'd%20have%20a%20Switch%20control%20with%20the%20condition%20based%20on%20the%20workshop%20attended.%20If%20the%20workshop%20was%20Public%20Speaking%20then%20the%20flow%20would%20be%20to%20add%20a%20SharePoint%20Create%20item%20action%20to%20the%20Public%20Speaking%20list.%20If%20the%20workshop%20was%20something%20else%2C%20e.g.%20Communications%20%2C%20then%20the%20flow%20action%20in%20that%20case%20would%20be%20to%20create%20an%20item%20in%20the%20Communications%20list.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EYou%20can't%20generate%20an%20analysis%20per%20list.%20You'd%20need%20to%20do%20that%20with%20Power%20Bi%20or%20something%20similar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Wanderlust
Visitor

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. Each answer is equal to a different workshop that was held.

 

I know that this is already possible to do. What would be even more interesting to do is to receive filled-in forms into folders within Sharepoint. Every folder would then contain only filled in forms concerning a particular workshop. For example, the folder called Public speaking would contain all filled-in forms concerning Public speaking workshop. Is it possible to do this?

 

Last but not least, is it possible to generate analysis per created folder? Thus, I'd have analysis on every workshop that was held separately.

 

Thanks loads for your help!

 

Ester

1 Reply

@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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies