Forms - Can sections create different lines in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1600421%22%20slang%3D%22en-US%22%3EForms%20-%20Can%20sections%20create%20different%20lines%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1600421%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20separate%20sections%20of%20a%20form%20link%20to%20different%20lines%20in%20a%20linked%20excel%20file%3F%20Where%20section%201%20is%20one%20line%2C%20and%20section%202%20is%20a%20separate%20line%20of%20the%20same%20excel%20file%3F%3CBR%20%2F%3E%3CBR%20%2F%3EOr%20can%20I%20create%20a%20yes%2Fno%20branch%20which%20leads%20to%20a%20new%20blank%20form%20for%20the%20person%20to%20fill%3F%20(Either%20ends%20it%20or%20restarts%20it%3F)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1600421%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1601278%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20-%20Can%20sections%20create%20different%20lines%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1601278%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Carol%20(%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F765255%22%20target%3D%22_blank%22%3E%40criley03%3C%2FA%3E%26nbsp%3B)%2C%20neither%20of%20your%20wishes%20is%20possible.%20The%20questions%20in%20different%20sections%20of%20the%20form%20will%20all%20be%20on%20the%20same%20row%20in%20the%20underlying%20spreadsheet.%20What%20you%20could%20do%20is%20to%20use%20a%20flow%20in%20Power%20Automate%20to%20get%20the%20response%20details%20and%20then%20have%20an%20action%20to%20add%20the%20answers%20to%20questions%201%20to%204%20to%20a%20row%20in%20a%20table%20in%20Excel%20(not%20the%20underlying%20spreadsheet%20but%20a%20new%20spreadsheet)%2C%20then%20follow%20it%20with%20another%20action%20to%20add%20the%20answers%20to%20questions%205%20to%208%20into%20another%20row%20in%20the%20same%20Excel%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBranching%20just%20takes%20you%20to%20different%20questions%20in%20the%20same%20form%2C%20it%20can't%20load%20a%20new%20form%20or%20re-start%20the%20current%20one.%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%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605637%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20-%20Can%20sections%20create%20different%20lines%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605637%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much%20for%20your%20quick%20reply%2C%20you%20saved%20me%20a%20lot%20of%20time.%20I%20greatly%20appreciate%20it%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Can separate sections of a form link to different lines in a linked excel file? Where section 1 is one line, and section 2 is a separate line of the same excel file?

Or can I create a yes/no branch which leads to a new blank form for the person to fill? (Either ends it or restarts it?)

2 Replies

Hi Carol (@criley03 ), neither of your wishes is possible. The questions in different sections of the form will all be on the same row in the underlying spreadsheet. What you could do is to use a flow in Power Automate to get the response details and then have an action to add the answers to questions 1 to 4 to a row in a table in Excel (not the underlying spreadsheet but a new spreadsheet), then follow it with another action to add the answers to questions 5 to 8 into another row in the same Excel table.

 

Branching just takes you to different questions in the same form, it can't load a new form or re-start the current one.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Thank you so much for your quick reply, you saved me a lot of time. I greatly appreciate it @RobElliott