Answered

Updating excel column - how to move to next cell down ?

(0) Share

Report

Posted on by jpreston4

171

Hi, i have a PA Desktop flow that takes values from a internal website and copies them to excel column. The values get retrieved but just update the same cell i.e. overwrite each other.

So I created a subflow to set variable to 0 and then in the write to excel worksheet command , I set this value to Row , followed by Increase variable by 1. But its still overwriting the 1st excel cell. Any ideas ? Thanks

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

PetrosF-MSFT on at

Like (0)

Report

Hi @jjpreston291

Could you share a screenshot of all the desktop flow so that we could check if there is an issue with the logic?

Thank you!

Was this reply helpful? Yes No
jpreston4 171 on at

Like (0)

Report

Hi, yes, that was the fault. My set var was mistakenly in the loop so kept resetting. I assume the set/increase variable is the best way to update each row in say an excel file.

Was this reply helpful? Yes No