Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
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

  • Infinity1 Profile Picture
    14 on at
    Re: Extracting Specific Cell Data

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

  • trice602 Profile Picture
    13,760 Super User 2025 Season 1 on at
    Re: Extracting Specific Cell Data

    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
    Re: Extracting Specific Cell Data

    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
    13,760 Super User 2025 Season 1 on at
    Re: Extracting Specific Cell Data

    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

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow