SOLVED

How can I reset the results?

%3CLINGO-SUB%20id%3D%22lingo-sub-1162952%22%20slang%3D%22en-US%22%3EHow%20can%20I%20reset%20the%20results%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1162952%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20form%20and%20quiz.%20Tested%20a%20couple%20of%20times%20and%20made%20changes%20on%20the%20question%20and%20sections.%20I%20deleted%20all%20the%20responses%2C%20but%20when%20I%20submit%20a%20new%20one%2C%20the%20ID%20continues%20from%20the%20ones%20I've%20already%20deleted.%20I'm%20also%20using%20power%20automate%20to%20populate%20a%20spreadsheet%20on%20sharepoint%20as%20soon%20as%20a%20response%20is%20submitted.%20Because%20of%20the%20changes%2C%20my%20table%20now%20is%20giant%20because%20it%20is%20just%20adding%20the%20adjustments%20to%20the%20previous%20versions%3C%2FP%3E%3CP%3EHow%20do%20I%20reset%20everything%20to%20keep%20only%20the%20final%20version%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1162952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1163037%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20reset%20the%20results%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1163037%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20think%20this%20should%20be%20able%20to%20be%20done%20by%3CBR%20%2F%3E%3CBR%20%2F%3E1.)%20Going%20into%20forms.office.com%20and%20copy%20the%20form%20so%20you%20create%20a%20new%20one%20with%20all%20the%20right%20fields%20and%20no%20responses%3CBR%20%2F%3E2.)%20Amend%20the%20flow%20to%20use%20the%20new%20form%20in%20Power%20Automate%3CBR%20%2F%3E3.)%20Remove%20all%20the%20responses%20on%20the%20spreadsheet%20in%20SharePoint%20or%20create%20a%20new%20spreadsheet%20and%20adjust%20the%20Flow%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20helps%20and%20answers%20your%20question%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1576039%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20reset%20the%20results%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1576039%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Rontomizawa%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20you%20are%20doing%20great.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20facing%20the%20same%20struggle%20with%20a%20quiz%20that%20I%20have%20created%20with%20O365%20that%20was%20linked%20to%20an%20excel%20sheet%20on%20one%20drive%20%26amp%3B%20I%20was%20wondering%20how%20have%20you%20managed%20to%20link%20the%20points%20for%20each%20question%20to%20the%20excel%20sheet%20since%20I%20couldn't%20find%20them%20in%20Power%20Automate's%26nbsp%3BDynamic%20content.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Visitor

I created a form and quiz. Tested a couple of times and made changes on the question and sections. I deleted all the responses, but when I submit a new one, the ID continues from the ones I've already deleted. I'm also using power automate to populate a spreadsheet on sharepoint as soon as a response is submitted. Because of the changes, my table now is giant because it is just adding the adjustments to the previous versions

How do I reset everything to keep only the final version?

2 Replies
Highlighted
Best Response confirmed by Rontomizawa (Regular Visitor)
Solution
Hi,

I think this should be able to be done by

1.) Going into forms.office.com and copy the form so you create a new one with all the right fields and no responses
2.) Amend the flow to use the new form in Power Automate
3.) Remove all the responses on the spreadsheet in SharePoint or create a new spreadsheet and adjust the Flow

Hope that helps and answers your question

Best, Chris
Highlighted

Hello Rontomizawa, 

I hope you are doing great. 

I am facing the same struggle with a quiz that I have created with O365 that was linked to an excel sheet on one drive & I was wondering how have you managed to link the points for each question to the excel sheet since I couldn't find them in Power Automate's Dynamic content.