Answered

How to copy Excel columns (values) to another file in Sharepoint?

(0) Share

Report

Posted on by ahmadbutt

255

If I run the Flow I don't get errors. When I try to open the new file I can't. I get an error that the file is damaged. What I need is that the 'File Content' = 'id' and 'id2' is copied in a new file. I KNOW that it is possible to copy a content file, but I don't need the WHOLE content of the file/table, I only need the values of 'id' and 'id2'. Is there a way to select/copy the range from the Excel file, like C8 to D9 and add column names for the values? Or can someone tell me what I need to do to let my Flow work right.

I hope someone can help me out.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-alzhan-msft on at

Like (0)

Report

Hi @ahmadbutt ,

Do you want to copy the 'id' and 'id2' column to a new excel table?

Or do you want to copy the 'id' and 'id2' of each row to a corresponding file?

If you want to copy the 'id' and 'id2' of each row to with a corresponding file, yo just need to update the File extension to .txt in the "Create file" in your current flow.

If you want to copy the 'id' and 'id2' column to a new excel table, you need to create table with column 'id' and column 'id2', and then you could save the 'id' and 'id2' of each row to the new table.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
ahmadbutt 255 on at

Like (0)

Report

Thanks for your help @v-alzhan-msft!

Or do you want to copy the 'id' and 'id2' of each row to a corresponding file? Yes

I changed the file to .txt and it works! I only did not get the exact result I was thinking of. See images.
What I got as result in the new .txt file: value of the second row only (99)
What I want as result in the new .txt file: column names (id and id2), all values of each column (first and second), like the Excel file (as a table), so column name then under it the values (first and second row).

I tried it with create a table, but I get an error that I can't overlap an existing table.

Was this reply helpful? Yes No
Verified answer

ahmadbutt 255 on at

Like (0)

Report

This worked for me.

Was this reply helpful? Yes No