web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extract info from an E...
Power Automate
Answered

Extract info from an Excel file that has no table format

(0) ShareShare
ReportReport
Posted on by 860
My trigger is "When an email arrives" filtered with the subject line and attachment. This type of email will happen daily, with only an .xlxs file attached. 
The file has lots of rows and columns filled. Unfortunately, I am unable to receive it in the "Table" format that Power Automate needs.
Been looking for ways to access this info to then use it in other flow. What I need to happen in the end, is adding all these new rows into an existing table. Have no idea how to acheive this. 
Tried creating in Sharepoint the file, then creating a table in that file. However, the table just goes on top of the non-table information. 
Maybe creating an array or something like that? 
Appreciate any input you might have!
Categories:
I have the same question (0)
  • RobElliott Profile Picture
    10,471 Super User 2026 Season 1 on at
    If it's not coming in a s a table then I don't think there's any way to process this with Power Automate as it always requires a table in the spreadsheet.
  • Suggested answer
    JayminTrivedi Profile Picture
    18 on at
    Table format is required when we are working with excel file in Power Automate. Without table format we cannot perform operations on excel file.
  • Verified answer
    rzaneti Profile Picture
    4,489 Super User 2026 Season 1 on at
     
    You can access data from Excel files with Power Automate even if it's not formatted as a table, by using Office Scripts or the Excel Graph API. I'm personally more familiar with the first option and think it's easier to implement, since you can execute an Office Script with the Run script action in Power Automate. In practice, the Office Scripts work like a VBA for Excel Online. 
     
    The downside of Office Scripts is the need of pro-coding knowledge at least in a basic level, since it works with TypeScript programming language. Another potential issue is that a few organizations restrict its usage. 
     
    To understand a little more about the Office Scripts, check the following articles that I wrote:
    - Sending values from Power Automate to Excel with Office Scripts: https://digitalmill.net/2024/01/17/sending-values-from-power-automate-to-excel-with-office-scripts/
    - Writing data into Excel ranges out of tables with Power Automate: https://digitalmill.net/2024/08/09/writing-data-into-excel-ranges-out-of-tables-with-power-automate/
     
    If this approach makes sense for you, I will be happy in helping you to build a Script that fits your needs. 
     
    Let me know if it works for you or if you need any additional help!
     
    If this is the answer to your question, please mark the post as Accepted Answer.
    If this answer helps you in any way, please give it a like.

    Check more Power Platform content on my website.
    Lets connect on LinkedIn.
  • Verified answer
    takolota1 Profile Picture
    4,980 Moderator on at
    This template Office Script allows you to get table-like data on a sheet, even if it isn’t formatted as a table

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 541

#2
Valantis Profile Picture

Valantis 479

#3
Vish WR Profile Picture

Vish WR 470

Last 30 days Overall leaderboard