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 / Extracting Specific Ce...
Power Automate
Unanswered

Extracting Specific Cell Data

(0) ShareShare
ReportReport
Posted on by 14

Hi, 

Current flow i'm attempting to extract an updated row's cell and paste it in another excel sheet's specific cell.

My flow stops at updating a row as it cannot find the ID of that row.

Any suggestions what i can do please?
image.png

Categories:
I have the same question (0)
  • trice602 Profile Picture
    16,239 Super User 2026 Season 1 on at

    Hi @Infinity1 ,

     

    It looks like in the second sheet, it cannot find the column2 keyvalue "3".  Can you confirm your second sheet has "3" in column2 in table2 please?  Paste in your sheet if you can - will be helpful!  Always glad to help! Tom

  • Infinity1 Profile Picture
    14 on at

    Hi @trice602,

     

    I understand now that this may be looking for a key value in Column 2. However, It will be Blank and only update according to what is entered in the first sheet from a specific row/column cell.

    In this instance, what what i do?

  • trice602 Profile Picture
    16,239 Super User 2026 Season 1 on at

    Hi @Infinity1 ,

     

    Yes you can do this by using Power Automate Desktop Excel actions. Essentially you can find the first free row in a worksheet and paste in your data by column.  Works like a charm!  Please mark as a solution if this was helpful! Always glad to help! Tom

     

    trice602_0-1691039635736.png

     

  • Infinity1 Profile Picture
    14 on at

    Thanks for the reply, However will this work on a sharepoint file? Thanks.

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 April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 796

#2
Valantis Profile Picture

Valantis 671

#3
Haque Profile Picture

Haque 551

Last 30 days Overall leaderboard