Unanswered

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

(0) Share

Report

Posted on by AlaskanPowrUser

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.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

eric-cheng 5,171 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
AlaskanPowrUser 15 on at

Like (0)

Report

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.

Was this reply helpful? Yes No