Create a Custom Worksheet From a Form Response Using Flow

%3CLINGO-SUB%20id%3D%22lingo-sub-2792847%22%20slang%3D%22en-US%22%3ECreate%20a%20Custom%20Worksheet%20From%20a%20Form%20Response%20Using%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2792847%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EI%20am%20trying%20to%20create%20a%20workflow%20where%20when%20a%20customer%20is%20interested%20in%20our%20services%20and%20filled%20out%20an%20inquiry%20form%2C%20their%20information%20is%20placed%20in%20a%20new%20excel%20workbook%20or%20worksheet%20with%20dynamic%20content%20(like%20customer%20name)%20as%20the%20workbook%2Fsheet%20title%20and%20then%20input%20the%20information%20to%20view%20in%20a%20portrait%20summary%20rather%20than%20the%20typical%20table%20format.%20This%20is%20so%20we%20can%20give%20the%20snapshot%20to%20the%20next%20person%20to%20review%20before%20reaching%20back%20out%20to%20connect%20with%20the%20inquiring%20customers.%20We%20then%20use%20this%20document%20to%20track%20other%20things%20from%20outside%20medical%20entities%20that%20are%20not%20things%20we%20will%20track%20in%20the%20table%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20having%20trouble%20creating%20this%20automation%20within%20flow.%20Could%20anyone%20be%20able%20to%20help%20me%20create%20this%20flow%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2792847%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2793039%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Custom%20Worksheet%20From%20a%20Form%20Response%20Using%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2793039%22%20slang%3D%22en-US%22%3EThis%20article%20will%20give%20you%20most%20of%20what%20you%20need.%20Just%20disregard%20the%20ms%20graph%20stuff%20and%20substitute%20in%20your%20form%20response%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.google.com%2Famp%2Fs%2Fsharepains.com%2F2020%2F08%2F04%2Fpopulate-excel-template-power-automate%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.google.com%2Famp%2Fs%2Fsharepains.com%2F2020%2F08%2F04%2Fpopulate-excel-template-power-automate%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am trying to create a workflow where when a customer is interested in our services and filled out an inquiry form, their information is placed in a new excel workbook or worksheet with dynamic content (like customer name) as the workbook/sheet title and then input the information to view in a portrait summary rather than the typical table format. This is so we can give the snapshot to the next person to review before reaching back out to connect with the inquiring customers. We then use this document to track other things from outside medical entities that are not things we will track in the table format.

 

I'm having trouble creating this automation within flow. Could anyone be able to help me create this flow?

 

Thank you!

1 Reply
This article will give you most of what you need. Just disregard the ms graph stuff and substitute in your form response:
https://www.google.com/amp/s/sharepains.com/2020/08/04/populate-excel-template-power-automate/