cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JRogers
Regular Visitor

Copy data from excel with no table

Hello!

I have some local experience working with Power Automate, I am currently trying to create an automate that picks up an excel that is automatically exported daily and sent to an email. I am trying to take the data from the attached excel and paste it into a another excel (via sharepoint), the problem is, is that the original file does not have a table so I am unsure how to take the data from one excel, with no table, and put it into another (existing) excel (table or not.)

I plan on having formulas to capture and sort the imported data for my needs (on separate tabs) to prevent issues with the import.

I would post my flow so far, but for this function I need, I can't find anything. All the solution are from table to table that I can find. I appreciate any help!

1 REPLY 1
takolota
Power Participant
Power Participant

@JRogers 


You can use Office Scripts to transform the data into an Excel table.

 

https://youtu.be/v-_joMcPpLI

 

https://docs.microsoft.com/en-us/office/dev/scripts/develop/scripting-fundamentals
(See the table section in the docs)

 

 

Alternatively if you can have the emails send a CSV version of the file, I also have a template for that.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/td-p/1508191

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,998)