How can I get Current Item row in my excel data so I can write to excel without a row counter

Like (0) Share

Report

Posted on 29 Sep 2023 20:29:44 by chucknb28409

I have a desktop flow that needs to read from an Excel worksheet, goes through each row of data (using For each), then has to write to Excel worksheet on a specific column but on the current row where the For each is currently at. What can I put into the Row area of the Write to Excel worksheet action so I can refer to the %CurrentItem% row? Is there a way to do this without counting the row number in a variable? There must be some system information on what row you are currently at, it seems silly to have to create a row counter to accomplish this when the system knows what row it is at...

All responses (2)

Answers (1)

Verified answer

Michael E. Gernaey 45,301 Super User 2025 Season 2 on 01 Oct 2023 at 00:17:29

Like (1)

Report

Re: How can I get Current Item row in my excel data so I can write to excel without a row counter

Hi @chucknb28409 ,

If I might suggest, check out this video so you have a solid reference of using the Excel Desktop PA features.

How to use Excel in Power Automate Desktop

Also, here is the correct forum to ensure you get the best support
Power Automate Desktop - Power Platform Community (microsoft.com)

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey