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