SOLVED

Forms and SharePoint Document Control

%3CLINGO-SUB%20id%3D%22lingo-sub-277873%22%20slang%3D%22en-US%22%3EForms%20and%20SharePoint%20Document%20Control%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277873%22%20slang%3D%22en-US%22%3E%3CP%3EAfternoon%20All%2C%3C%2FP%3E%3CP%3EI've%20created%20a%20Form%20which%20links%20to%20an%20Excel%20sheet%20within%20a%20SharePoint%20document%20library.%26nbsp%3B%20The%20SharePoint%20document%20library%20has%20version%20control%20set%20on%20it%20so%20that%20you%20need%20to%20check%20items%20out%20and%20in%20again%20as%20you%20edit%20them.%3C%2FP%3E%3CP%3EI've%20performed%20some%20test%20responses%20and%20my%20results%20are%20not%20being%20fed%20into%20the%20Spreadsheet.%26nbsp%3B%20I%20tried%20the%20suggestion%20in%20another%20thread%20about%20changing%20the%20'false'%20to%20'true'%20in%20the%20'Open%20in%20Excel'%20link%20from%20the%20form%2C%20and%20that%20does%20indeed%20work%20as%20a%20one%20off.%26nbsp%3B%20However%2C%20subsequent%20entries%20are%20then%20not%20recorded%20in%20the%20sheet.%26nbsp%3B%20Repeating%20the%20'false%20%2F%20true'%20trick%20would%20be%20fine%20except%20I%20want%20to%20perform%20calculations%20within%20the%20sheet%20based%20off%20the%20answers%20and%20I%20then%20have%20another%20'parent'%20Excel%20sheet%20which%20refers%20to%20a%20series%20of%20Form%20outputs%20to%20amalgamate%20the%20results%20(so%20updating%20the%20location%20in%20the%20parent%20Excel%20sheet%20formula%20each%20time%20I%20'refresh'%20(fales%2Ftrue)%20the%20sheet%20is%20unworkable).%3C%2FP%3E%3CP%3EMy%20question%20is%20-%20are%20Forms%20compatible%20with%20SharePoint%20version%20control%3F%26nbsp%3B%20If%20'Yes'%2C%20how%20do%20I%20get%20my%20results%20to%20populate%20automatically%3F%3C%2FP%3E%3CP%3EMany%20Thanks%3C%2FP%3E%3CP%3EMatt%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-277873%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278006%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20and%20SharePoint%20Document%20Control%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278006%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%3C%2FP%3E%3CP%3EThanks%20for%20the%20speedy%20reply.%26nbsp%3B%26nbsp%3BI%20think%20we're%20going%20to%20have%20to%20put%20it%20into%20another%20folder.%3C%2FP%3E%3CP%3EAgain%2C%20thanks%20for%20the%20reply%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-277980%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20and%20SharePoint%20Document%20Control%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-277980%22%20slang%3D%22en-US%22%3ESo%20Forms%20out%20of%20the%20box%20doesn't.%20However%20you%20could%20accomplish%20this%20with%20Flow%2C%20but%20you%20would%20have%20to%20get%20real%20fancy%20with%20it.%20You%20could%20take%20your%20responses%2C%20have%20flow%20handle%20the%20check%20out%2C%20update%2C%20check%20back%20in%20etc.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20reason%20for%20the%20check%20in%20%2F%20out%20being%20on%3F%20Is%20it%20just%20a%20by%20product%20of%20the%20location%20already%20having%20this%20set%3F%20Can't%20move%20the%20file%20to%20another%20library%20or%20possibly%20you%20could%20just%20write%20responses%20to%20a%20SharePoint%20list%20itself%3F%3C%2FLINGO-BODY%3E
New Contributor

Afternoon All,

I've created a Form which links to an Excel sheet within a SharePoint document library.  The SharePoint document library has version control set on it so that you need to check items out and in again as you edit them.

I've performed some test responses and my results are not being fed into the Spreadsheet.  I tried the suggestion in another thread about changing the 'false' to 'true' in the 'Open in Excel' link from the form, and that does indeed work as a one off.  However, subsequent entries are then not recorded in the sheet.  Repeating the 'false / true' trick would be fine except I want to perform calculations within the sheet based off the answers and I then have another 'parent' Excel sheet which refers to a series of Form outputs to amalgamate the results (so updating the location in the parent Excel sheet formula each time I 'refresh' (fales/true) the sheet is unworkable).

My question is - are Forms compatible with SharePoint version control?  If 'Yes', how do I get my results to populate automatically?

Many Thanks

Matt

2 Replies
best response confirmed by Matt Doherty (New Contributor)
Solution
So Forms out of the box doesn't. However you could accomplish this with Flow, but you would have to get real fancy with it. You could take your responses, have flow handle the check out, update, check back in etc.

Is there a reason for the check in / out being on? Is it just a by product of the location already having this set? Can't move the file to another library or possibly you could just write responses to a SharePoint list itself?

Hi @Chris Webb

Thanks for the speedy reply.  I think we're going to have to put it into another folder.

Again, thanks for the reply