Extract data from Excel to other Excel

[eyden]

Hello
I'm trying to create a flow but I can't find how to do it.

Once a week, someone leaves an Excel document in a Sharepoint folder, and when that happens they notify us to check the data.
Once the information is verified, we have to copy that data into another Excel document that Power BI will work with.
The problem is that both Excel files do not have tables, because the information sometimes comes in a .csv file, so the data is not in any table.
In the flow, when I try to access that source document, I get the message that it needs a table name.
Hence my question about whether it is possible to copy data from one Excel to another without the data being in any table.
I attach screenshots of the source and destination files, as well as the flow.

Best Regards.

[eliotcole]

Hi, @eyden, it'd be super helpful for you to show us what you have so far. Just edit into your question above:

1. A screenshot (or a few) of your full flow.
2. Any sample/example data you can include.

Just obfuscate where necessary.

This helps out anyone that wants to assist in:

1. Getting much better context of what you're trying to do and with what. 👍
   
   and
   
   
2. Shows us that we're not just doing your job for you. 😉😅

[eyden]

.

[eliotcole]

Excellent stuff, @eyden, thanks ... just copy that into your original question, in case this gets a lot of replies and anyone else that wants to help will have more to work with up front.

👍