Create a SharePoint folder structure based on Form submission

%3CLINGO-SUB%20id%3D%22lingo-sub-1927475%22%20slang%3D%22en-US%22%3ECreate%20a%20SharePoint%20folder%20structure%20based%20on%20Form%20submission%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1927475%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning!%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20looking%20to%20have%20a%20simple%20MS%20Form%20submission%20drive%20the%20creation%20of%20a%20preset%20folder%20structure%20and%20populate%20a%20few%20documents%20within%20those%20created%20folders%20-%20ideally%20driven%20by%20the%20selections%20made%20in%20the%20form.%26nbsp%3B%20Below%20illustrates%20what%20I%20have%20so%20far%20and%20it%20keeps%20failing%20at%20the%20Create%20HTML%20Table%20stage.%26nbsp%3B%20This%20is%20essentially%20what%20I%20am%20looking%20to%20do%3A%3C%2FP%3E%3CP%3EMS%20Forms%20to%20ask%203%20questions%3A%26nbsp%3B%20What%20is%20the%20new%20account%20name%2C%20serial%20number%2C%20and%20aircraft%20model%20type.%26nbsp%3B%3C%2FP%3E%3CP%3EUpon%20submission%20of%20that%20form%2C%20I%20want%20Automate%20to%20go%20into%20the%20SharePoint%20location%20and%20create%20a%20new%20folder%20that%20is%20named%20based%20on%20questions%201%20%26amp%3B%202%20in%20the%20Form%20(%22Serial%20Number%2C%20Account%20Name%22)%20and%20have%20that%20folder%20created%20inside%20of%20a%20pre-existing%20folder%20(aircraft%20model%20type)%20that%20is%20determined%20by%20the%20third%20question%20in%20the%20Form.%26nbsp%3B%20Is%20this%20possible%3F%3F%20Thank%20you!!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20image-alt%3D%22Screen%20Shot%202020-11-24%20at%2010.30.31%20AM.png%22%20style%3D%22width%3A%20662px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235769iDCDB470A1DD9C905%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202020-11-24%20at%2010.30.31%20AM.png%22%20alt%3D%22Screen%20Shot%202020-11-24%20at%2010.30.31%20AM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1927475%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Good Morning! 

I'm looking to have a simple MS Form submission drive the creation of a preset folder structure and populate a few documents within those created folders - ideally driven by the selections made in the form.  Below illustrates what I have so far and it keeps failing at the Create HTML Table stage.  This is essentially what I am looking to do:

MS Forms to ask 3 questions:  What is the new account name, serial number, and aircraft model type. 

Upon submission of that form, I want Automate to go into the SharePoint location and create a new folder that is named based on questions 1 & 2 in the Form ("Serial Number, Account Name") and have that folder created inside of a pre-existing folder (aircraft model type) that is determined by the third question in the Form.  Is this possible?? Thank you!!

Screen Shot 2020-11-24 at 10.30.31 AM.png

0 Replies