Unanswered

Find first free row and write to that

(0) Share

Report

Posted on by pukasleter

Hello,
I am trying to create a flow that searches from an excel for the first free cell in a column and enters something in that row. Is this possible?
Thanks for the help

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report
Hey @pukasleter , yes the above is possible.

For Power Automate Desktop, you can search First Free Row and select the action.

For Power Automate Cloud/Browser, you can directly use the action called add a row in a table. This will directly add something to the first free row of your excel.

Or, if you had a question like this where, you are searching for a cell that is empty or first free column, then you can also use an action like List rows present in a table. And inside that, in the filter option add a column name and give empty parameters to it, so that it finds empty cells and in top count you can give 1 so that it filters out the first free column.

If you have any doubts just reply.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi there, i Have a file which i am counting rows from . Lets say its "Week1". I want to update another file lets say its "Rows Counted", in the next free row/cell in a column called "totals". This happens every week so i need a formula or expression to help me look for the next free row every week. This is what my flow looks like so far

1. Manual Trigger
2. List rows present in a table (Location, Library, file, table of file "Week1.xlsx")
3. Compose (Input - length(body('List_rows_present_in_a_table')?['value']))
4. List rows present in a table 2 (Location, Library, file, table of file "Rows Counted.xlsx")
5. Apply to each (Output - Value of List rows present in a table 2)
6. Update a row (Location, Library, file, table of file Rows Counted.xlsx), Key column is the ID column of my excel file, i don't know what the key value would be, and the column "totals" has the output of the composed output

What do i need to add because this does not work

Was this reply helpful? Yes No