You’re offline. This is a read only version of the page.
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!
You can use Office Scripts to transform the data into an Excel table.
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
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
