web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Updating excel column ...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by 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

jjpreston291_0-1606251138072.png

 

I have the same question (0)
  • Verified answer
    PetrosF-MSFT Profile Picture
    Microsoft Employee on at

    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!

  • jpreston4 Profile Picture
    171 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard