Skip to main content

Notifications

Power Automate - Using Connectors
Answered

obtaining data from excel files in email attachments (not structured as a table!)

(0) ShareShare
ReportReport
Posted on by 15

Existing process:
Email is sent to my inbox, 5-30 times a day.
Email contains 1 attachment, always an .xlsx worksheet. 
Data Always begins on B8, going through N8, and Down for 1-20 records on any given day. 
Data is NOT in a formatted table in excel. I do not have the ability to have the data formatted table, because a third-party is sending the email to me via their process. 

I need to create a record(row) in sharepoint for every record(row) in the excel file on the attachment. The sharepoint list will hold the data to be consumed via PowerApps. 

Any direction on how to achieve getting the desired data from an emailed excel attachment into sharepoint would be greatly appreciated. I am able to supply additional information upon request very rapidly. 

  • AlaskanPowrUser Profile Picture
    AlaskanPowrUser 15 on at
    Re: obtaining data from excel files in email attachments (not structured as a table!)

    I did not fully read your answer, and it shows! 🙂 

    I feel extraordinarily silly not knowing about the create a table action.  I thank you for this reply! 
    I went like, way too far, and created a Parserr account to send my file to Parserr and simply have them email it right back - they create it as a table.

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: obtaining data from excel files in email attachments (not structured as a table!)

    @AlaskanPowrUser 

    @eric-cheng is correct in that you do need a table.  Since you know where the data is, you may be able to use the Excel Create Table action to create a table.  Then, you can use the list rows in a table action to get the data and save it to SharePoint.

     

     

     

  • eric-cheng Profile Picture
    eric-cheng 5,171 on at
    Re: obtaining data from excel files in email attachments (not structured as a table!)

    Hi @AlaskanPowrUser ,

     

    The Excel connector requires a table.

     

    There are a few other options which may work:

     

    * Run Office Scripts with Power Automate here 

     

    * Graph API here 

     

    There are a few other options like using VBscript to create an ODBC connection so that you can interact with your Excel like a SQL database but I suggest looking at the two options above first.

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard

Featured topics