Answered

Write to excel worksheet all from row 2 to last row

(0) Share

Report

Posted on by craigmon

Hi Guys,

I want to be able to write 'Commercial' in all rows to the last row in column 20. Write to excel only allows me to do this to a certain cell. Can this be done?

Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Pochoide 111 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @craigmon, you can get all the rows from the table, then loop over them using its output and updating the corresponding records to 'Commercial'. Also, you could add a condition if you need to except any row.
This flow worked for me:

Was this reply helpful? Yes No
craigmon on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, can this been done is PAD?

Was this reply helpful? Yes No
Pochoide 111 on at

Like
a
(0)

Report
Copy link

Link copied!

@craigmon for PAD it's very different. I don't know much about PAD, but I got it working with this flow
Hope it helps!

Was this reply helpful? Yes No
Verified answer

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is a sample flow.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

Regards
Kaif

Was this reply helpful? Yes No
craigmon on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for this. all works except I cant figure out how you have added 'FirstFreeRowOnColumn - 1'. I can only use FirstFreeRowOnColumn otherwise I get errors.

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Get first free row on column from Excel worksheet - Retrieve the first free row, given the column of the active worksheet. and the output variable produced is FirstFreeRowOnColumn(i.e. last rows +1).
For example if a column has 10 rows then output will be 10(last rows) +1(first free row) = 11. Thats why 1 is substracted from FirstFreeRowOnColumn( FirstFreeRowOnColumn -1) to find the last row.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

Regards
Kaif

Was this reply helpful? Yes No
craigmon on at

Like
a
(1)

Report
Copy link

Link copied!

Great thank you. All works as expected. Appreciate the help

Was this reply helpful? Yes No