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

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Extracting only some cells from Excel and entering in a second workbook

(0) ShareShare
ReportReport
Posted on by 25

Forgive me if I missed it but I have not seen anything that quite addresses my challenge and I am starting to chase myself in mental circles.

 

I need a flow that will look for a row of data in Excel File1 based on the contents of the cell in Column 1. 

I need the data on the entire row extracted.

I then need to enter that data, selectively, over two rows in Excel File2.  In other words, while I want to extract the whole row from File1 I do not want to simply write that row into File2.  File1 Column1 might go into File2 Column3, etc.  I see that I can use Add Row to Table and specify what goes into each column - GREAT!  But I am lost when it comes actually specifying the data from File1.

 

A very simple example just to illustrate the point.

File1 - what I have

Column1   Column2    Column3

Bob           Blue            Buick

 

File2 -  What I am trying to create

Column1     Column2   Column3    Column4    Column5

B                  Bob           NTX            Buick          Blue

 

Thanks in advance!

I have the same question (0)
  • GeoffRen Profile Picture
    Microsoft Employee on at
    Re: Extracting only some cells from Excel and entering in a second workbook

    I would recommend using Office Scripts, specifically Office Scripts with Power Automate. This is the 'Run Script' action on the Excel connector. With Office Scripts you can use the 'Run Script' action to execute javascript against a workbook. So you can do nearly anything you want within Excel. I can help provide a script to start with if you want, though could you provide a larger example of the inputs and outputs?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 560 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 347 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard