SOLVED

Merging Columns Created from Branching a Form

%3CLINGO-SUB%20id%3D%22lingo-sub-1201862%22%20slang%3D%22en-US%22%3EMerging%20Columns%20Created%20from%20Branching%20a%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1201862%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20use%20Forms%20to%20help%20out%20my%20manager%20team%20but%20I'm%20having%20a%20little%20trouble%20with%20one%20part.%20The%20form%20will%20open%20with%20asking%20which%20Manager%20they%20are%20which%20then%20branches%20to%20a%20new%20section%20which%20asks%20which%20employee%20the%20form%20is%20being%20filled%20out%20for.%20In%20order%20to%20limit%20the%20list%20that%20each%20manager%20has%20to%20go%20through%20to%20find%20an%20employee%2C%20each%20manager%20has%20their%20own%20%22employee%20section%22%20with%20a%20drop%20down%20that%20only%20includes%20their%20employee.%20(See%20Capture.PNG)%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20works%20great%20when%20you're%20filling%20out%20the%20form.%20You%20specify%20yourself%20as%20the%20manager%2C%20click%20next%2C%20and%20get%20a%20drop%20down%20with%20only%20your%20employees%20instead%20of%20the%20entire%20org.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20problem%20comes%20in%20when%20looking%20at%20the%20results%20in%20Excel%20because%20each%20branch%20gets%20it's%20own%20column%20of%20data%20but%20when%20I%20want%20to%20analyze%20the%20data%2C%20all%20of%20the%20Employees%20should%20be%20in%20a%20single%20column.%20(See%20Capture2.PNG).%20Since%20I%20have%2011%20managers%2C%20that%20means%20I'll%20have%2011%20columns%20of%20employee%20data%20when%20really%20I%20just%20want%201.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20I%20could%20fix%20this%20with%20some%20clever%20Flow-ing%2C%20but%20before%20I%20dive%20down%20that%20rabbit%20hole%20I%20was%20curious%20if%20there's%20either%20a%20way%20to%20%22auto-merge%22%20the%20columns%20or%20perhaps%20tell%20forms%20to%20treat%20questions%20from%20different%20sections%20the%20same.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1201862%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBranching%3C%2FLINGO-LABEL%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-1202313%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20Columns%20Created%20from%20Branching%20a%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1202313%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570986%22%20target%3D%22_blank%22%3E%40jlindine%3C%2FA%3E%26nbsp%3Bthere's%20no%20way%20to%20auto-merge%20the%20columns%20in%20Forms%20nor%20a%20way%20to%20tell%20it%20to%20treat%20questions%20from%20different%20sections%20the%20same.%20So%20you%20will%20need%20to%20use%20a%20flow%20in%20Power%20Automate%20achieve%20what%20you%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1205405%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20Columns%20Created%20from%20Branching%20a%20Form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1205405%22%20slang%3D%22en-US%22%3E%3CP%3E%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%3BDarn.%20Figured%20as%20much%20but%20thanks%20for%20the%20confirmation.%20Flow%20it%20is!%20Thanks%20for%20the%20quick%20response.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Everyone,

 

I'm trying to use Forms to help out my manager team but I'm having a little trouble with one part. The form will open with asking which Manager they are which then branches to a new section which asks which employee the form is being filled out for. In order to limit the list that each manager has to go through to find an employee, each manager has their own "employee section" with a drop down that only includes their employee. (See Capture.PNG) 

This works great when you're filling out the form. You specify yourself as the manager, click next, and get a drop down with only your employees instead of the entire org.

The problem comes in when looking at the results in Excel because each branch gets it's own column of data but when I want to analyze the data, all of the Employees should be in a single column. (See Capture2.PNG). Since I have 11 managers, that means I'll have 11 columns of employee data when really I just want 1. 

 

I'm sure I could fix this with some clever Flow-ing, but before I dive down that rabbit hole I was curious if there's either a way to "auto-merge" the columns or perhaps tell forms to treat questions from different sections the same.

Thanks for your help!

2 Replies
best response confirmed by jlindine (New Contributor)
Solution

@jlindine there's no way to auto-merge the columns in Forms nor a way to tell it to treat questions from different sections the same. So you will need to use a flow in Power Automate achieve what you want.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott Darn. Figured as much but thanks for the confirmation. Flow it is! Thanks for the quick response.