Using forms to populate an existing Excel file

%3CLINGO-SUB%20id%3D%22lingo-sub-1278460%22%20slang%3D%22en-US%22%3EUsing%20forms%20to%20populate%20an%20existing%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1278460%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20question%20related%20to%20forms.%20I%20work%20in%20Teams%20on%20a%20excel%20file%20(name%3A%20File%20A)%20that%20I%20need%20my%20team%20to%20populate%20with%20data.%20Now%20File%20A%20is%20quite%20big%20(and%20for%20outsiders%20a%20bit%20messy%20%3A))%20and%20I%20do%20not%20want%20my%20team%20members%20to%20go%20into%20File%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStill%2C%20I%20need%20their%20help%20on%20gathering%20information.%20I%20thought%20of%20using%20Microsoft%20Forms%20to%20help%20me.%20I%20would%20set%20up%20a%20questionnaire%2C%20let%20everyone%20fill%20it%20out%20and%20I%20have%20my%20data%20in%20a%20new%20excel%20file%20(name%3A%20File%20B).%20Now%20the%20thing%20is%2C%20data%20would%20come%20in%20every%20now%20and%20then%2C%20meaning%20I%20regularly%20have%20to%20go%20back%20to%20File%20B%20and%20copy%20my%20data%20in%20to%20File%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20I%20can%20let%20the%20form%20populate%20File%20A%20directly%20and%20choose%20where%20the%20data%20would%20land%20manually%3F%20And%20if%20so%2C%20how%3F%3CBR%20%2F%3EIf%20not%2C%20would%20any%20of%20you%20have%20a%20suggestion%20how%20to%20best%20tackle%20my%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1278460%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1278575%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20forms%20to%20populate%20an%20existing%20Excel%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1278575%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F607865%22%20target%3D%22_blank%22%3E%40Laurens2207%3C%2FA%3E%26nbsp%3Bthe%20form%20can't%20populate%20File%20A%20directly%20but%20you%20can%20grab%20each%20form%20response%20with%20a%20flow%20in%20Power%20Automate%20and%20add%20the%20answers%20to%20each%20question%20to%20the%20appropriate%20column%20in%20a%20table%20in%20File%20A%20on%20OneDrive.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi everyone,

 

I have a question related to forms. I work in Teams on a excel file (name: File A) that I need my team to populate with data. Now File A is quite big (and for outsiders a bit messy :)) and I do not want my team members to go into File A.

 

Still, I need their help on gathering information. I thought of using Microsoft Forms to help me. I would set up a questionnaire, let everyone fill it out and I have my data in a new excel file (name: File B). Now the thing is, data would come in every now and then, meaning I regularly have to go back to File B and copy my data in to File A.

 

Is there a way I can let the form populate File A directly and choose where the data would land manually? And if so, how?
If not, would any of you have a suggestion how to best tackle my problem?

 

Thanks for your help!

1 Reply
Highlighted

@Laurens2207 the form can't populate File A directly but you can grab each form response with a flow in Power Automate and add the answers to each question to the appropriate column in a table in File A on OneDrive.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User