Answered

How to write values to multiple rows in excel when using "write to excel worksheet"

(1) Share

Report

Posted on by SH-04111327-0

I am reading from two excel worksheets in my flow, and writing the data from those into a third new one (merging the data).

The issue is that the merged data is only writing onto row 1

The problem is because the "Write to Excel worksheet" action I have is set to write the data there and I know that is wrong...

But I can't see how to write the data onto rows using the other "write mode" options (e.g. on currently active cell, on named cells), so that each value has its own cell in rows in column A.

Do I need to initiate a variate and set a counter to do this, or can this be done within the write action?

Screenshots attached below for reference - One contains the output with the issue (data all on one row) and one screenshot shows how i want the data to be written (row by row in column A)

Thanks for any help

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

eetuRobo 4,549 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

If you want to write to multiple rows in excel then the variable has to be either a list or datatable. Then with "On specified cell" writing mode you give it cell that the list or datatable starts from.

Your mergedData2 is just string of text so if you write it on Column A Row 1 then the whole text will be in that one cell. You might want to have the "mergedData2" as a list.

In your Set variable you are settin mergedData2 to be string of opening and closing square brackets.

If you want it to be empty list then add percent signs around the square brackets like: %[]% or use create a new list -action.

And merged data should looke like this:

Or just go with the list actions:

If you have the data as a list or datatable then you can write that into Excel column A row 1 and then the list will be one item per row like so:

Example 2:

Was this reply helpful? Yes No
SH-04111327-0 10 on at

Like (1)

Report
Copy link

Link copied!
Thanks so much for your help, this process worked for me!

For reference, another mistake I was making was when I was trying to add variables or lists, instead of following the syntax
%mergedData + mergedData2%

I was doing

%mergedData% + %mergedData2%

Closing each variable off with the % was obviously causing issues

Your advice on using a list and using the % sign around the [] parenthesis to create the empty list worked too :) really appreciate it!

Was this reply helpful? Yes No