Power Platform Community Forum Thread Details

Hi All,

New to this forum and also relatively new to power automate. What I am trying to do is and having trouble figuring out is how I would read data from one excel file and use that data to from another spreadsheet where that specific data will be stored. I'll be using a xlsx file to extract the data then putting it into a new excel file. Hope that information helps and someone here has a solution to it. Thankyou.

So I will be needing the items numbers read from this file and if they are not used to put that information into another file.

Categories:

Using flows

Hi,

Let's answer the first part.

Step1: How to read an excel file data.

Answer: You must first, create a Table using the Excel data. If the data is not in a Table already, then use the Create Table Action (Excel). Secondarily you would use the Lists Rows in a Table (Excel) Action. And then you use an Apply to Each action to Loop through the data returned in the List Rows in a Table Action.

Step2: The second part, apologies I do not follow:

I would read data from one excel file and use that data to from another spreadsheet where that specific data will be stored.

Are you saying you want to add the data you read in Step 1, to the 2nd excel file?

If you want to write data into the second file, you also need a Table, so that you can use the Create a Row (Table/Excel) Action.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey