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 175

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
    175 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 241 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 179

#3
Haque Profile Picture

Haque 159

Last 30 days Overall leaderboard