You’re offline. This is a read only version of the page.
Every day I receive an automated email that is generated from a SQL query, and I copy the whole table and then paste it into a different Excel file-- which is stored online in SharePoint, and many other people edit it there.
I want to know if this process can be automated. I assume the step of the table getting emailed to me is superfluous, but there has to be a way to automatically query and load a sql table into specific columns of a Sharepoint Excel sheet.
Do you have permissions to access the SQL data directly?
If so you should be able to use the SQL connector in Power Automate to pull in the table & then insert it into an Excel file.
If you can only access the table data by emailed table, what does the emailed table look like?
Is it HTML? Can you parse it like you would a CSV file?
Share
Report
All responses (
Answers (
4,980
