cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eyden
Frequent Visitor

Extract data from Excel to other Excel

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.


Archivo Origen.JPG

 

Archivo Destino.JPG

 

Flujo.JPG

3 REPLIES 3
eliotcole
Super User
Super User

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
Frequent Visitor

.

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.

👍

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,104)