Power Platform Community Forum Thread Details

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:

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 Many	Confirmed?	Select a Lot	Confirmed?
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.

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().

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.

Categories:

General topics