Forum Discussion
Combining data from Excel each day
I get an excel sheet sent to me each day. I have to manipulate it down to a basic one line table:
| Date | Units | Hours Spent |
| 08/16/2022 | 97 | 45.6 |
The excel sheet that comes to me the next day, I need to manipulate it down to units and hours spent and add the date column. I don't want to replace the data in the sheet that I did this to yesterday, instead I want to have it build a table that looks Like this:
| Date | Units | Hours Spent |
| 08/16/2022 | 97 | 45.6 |
| 08/17/2022 | 96 | 41 |
| 08/18/2022 | 99 | 56 |
How do I get the excel sheets that come in daily to combine in BI to a new table? Any help would be great.
powerautomate.microsoft.com helps you to save attachments from incomming emails to sharepoint. combine saved excel files can be done in power bi.
Save my email attachments to a SharePoint document library | Microsoft Power Automate
3 Replies
Hi, what about to use power automate? Save the excel file each time to sharepoint folder. in powerbi get data from sharepoint folder and transform data from excel sheets.
So you are saying use power automate to combine the excel sheets? I have never used that tool. If that is what would work, let me know.
powerautomate.microsoft.com helps you to save attachments from incomming emails to sharepoint. combine saved excel files can be done in power bi.
Save my email attachments to a SharePoint document library | Microsoft Power Automate
