Using multiply Forms and reporting them to excel but......

%3CLINGO-SUB%20id%3D%22lingo-sub-1483667%22%20slang%3D%22en-US%22%3EUsing%20multiply%20Forms%20and%20reporting%20them%20to%20excel%20but......%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1483667%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20i%20have%20several%20forms%20that%20i%20use%20together%20and%20when%20creating%20excel%20documents%20from%20each%20and%20combining%20them%20aren't%20an%20issue%2C%20the%20issue%20when%20refreshing%20to%20combined%20excel%20sheet%20and%20updating%20the%20submitted%20data%20daily%20isn't%20possible%20because%20Forms%20doesn't%20seem%20to%20save%20the%20submissions%20on%20a%20live%20basis.%26nbsp%3B%20Then%20the%20next%20issue%20to%20that%20when%20clicking%2C%20%22open%20in%20excel%22%26nbsp%3B%20opens%20another%20new%20excel%20sheet%20and%20not%20the%20the%20original%20so%20now%20my%20merged%20data%20will%20not%20properly%20update%2C%20and%20now%20i%20have%20an%20abundance%20of%20excel%20files%20being%20created%20from%20Forms%20because%20it%20doesn't%20use%20or%20update%20the%20original%20saved%20file%20it%20just%20creates%20another%20excel%20file......polluting%20my%20computer%20with%20excel%20files%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1483667%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

So i have several forms that i use together and when creating excel documents from each and combining them aren't an issue, the issue when refreshing to combined excel sheet and updating the submitted data daily isn't possible because Forms doesn't seem to save the submissions on a live basis.  Then the next issue to that when clicking, "open in excel"  opens another new excel sheet and not the the original so now my merged data will not properly update, and now i have an abundance of excel files being created from Forms because it doesn't use or update the original saved file it just creates another excel file......polluting my computer with excel files 

1 Reply

@donnyb to get over that problem you could have a flow in Power Automate for each form that saves each submission into the same excel file, so it automatically creates the combined file for you and it's always up to date.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User