Copy certain rows and pasting into another spreadsheet tab (sheet)

(0) Share

Report

Posted on by mzuc

Hello,

I am having trouble figuring out how to complete step 2

steps 1: new email comes in with an attachment, have that file save to a SharePoint location - DONE

step 2: take the data within that saved file and paste it into a separate already created SharePoint spreadsheet, but it need to be pasted into a certain cell within a certain sheet of that spreadsheet.

is this possible?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

leo85 609 on at

Like (0)

Report

Hi @mzuc ,

welcome to the forum. Could you please be a bit more precise. Are you talking about a SharePoint list and an Excel spreadsheet? At the moment is found like you want to put all the data in the file into a single cell. Is that what you want?

Generally, extracting data and putting it into a specific cell is possible as long as the cell is part of a table and you can identify the correct row.

Please post a screenshot of what you have already created and describe what the problem with your current solution is.

Regards,

Leo

Was this reply helpful? Yes No
mzuc 10 on at

Like (0)

Report

Hello @leo85

Thanks for the response.

I am trying to accomplish the following:

Take data [cells: A1:BH3] from a SharePoint excel file [file1][sheet1][A1:BH3] and place it into a separate existing SharePoint excel file [file2][sheet3][A6]

if i am understanding you, it would appear i need to create a table within [file1][sheet1] first

Was this reply helpful? Yes No
leo85 609 on at

Like (0)

Report

Hi @mzuc ,

ok. So you have two Excel files which are saved in SharePoint in you want to transfer data between them.

This is possible, as long as the data is formatted as a table in both Excel files.

1. Format the area you want (e.g. A1:BH3) as a table in both files.

2. Get the information from file 1 (e.g. action "list rows present in a table").

3. Write the information to file 2 (e.g. "Update a row" or "Add a row into a table")

For this to work, you must have a key column in the target table with which you can identify the row you want.

In your example you try to put a range (A1:BH3) into a cell (A6). If this is what you want you need to combine the data when you write to the target file.

Hope this helps.

Regards,

Leo

Was this reply helpful? Yes No