cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Law_Unprepared
New Member

Populating CSV columns with MS Forms responses.

I have a form with multiple multiple-choice sections, and I want to populate a CSV's columns with the options a user selects. Here are my test sections:

Law_Unprepared_0-1631226590426.pngLaw_Unprepared_1-1631226818546.png

 

 

I also want to leave blank columns between the populated columns. So if a user selects [Option 1, Option 3, Option 4, other_text] and [Answer 2, Answer 3], the first four columns of the output CSV would look like this:

Select ManyConfirmed?Select a LotConfirmed?
Option 1 Answer 2 
Option 3 Answer 3 
Option 4   
other_text   

 

 

I followed a solution in this post, which got me as far as creating one column displaying the user's answers once. 

Law_Unprepared_3-1631230441918.png

 

 

I'm having trouble adding multiple columns. 

 

Here's the flow as things stand.

* I get the row from the form's associated Excel Online sheet

* I get the desired string from its cell, and split it on ';' to format it as an array.

* I pass that array to Create CSV Table, ensuring columns are set as Custom, with a custom header and a value of @item().

Law_Unprepared_4-1631230791252.png

 

 

I think I need to pass multiple arrays, preferably with headers, but I don't know how to get there. I'll eventually want to populate a single column with data from multiple form responses too. 

 

Any help or recommended documentation is greatly appreciated. 

 

1 REPLY 1
Law_Unprepared
New Member

I've got a temporary workaround going that involves a locally-run VBA script, but I still would like some input as to how this can be done entirely in Automate. 

 

Work Around

1.) Create a "Base Array" that will be filled by a Select flow. 

Law_Unprepared_1-1631555336987.png

 

2.) Fill that Array with a Select flow.

Law_Unprepared_2-1631555363535.png

 

3.) Format the resulting CSV with a VBA script. 

Before: Law_Unprepared_3-1631555440692.png

 

After: Law_Unprepared_4-1631555486155.png

 

This gets me the result I'm looking for, but takes an extra step that isn't satisfying. Any input is appreciated. 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,875)