How to modify, save, and upload files to an online SharePoint folder each day?

Question

I download a report from an online platform we have, which exports as six Excel files (since the data is too large to fit on a single Excel spreadsheet). I save these exports to a network folder. For each file, I delete the first 26 rows manually and then upload them to a SharePoint folder online. I have a Power BI report connected to this SharePoint folder as a data source. Is there a way I could automate this process? Ideally, I'd want to automate when these files are saved to this network folder, the flow would automatically remove the first 26 rows from each file then save each of them and upload them to this specific SharePoint folder automatically each day. I download and save the Excel files each morning. Is this possible?

VJ04 · Answer

could you please share details on the network drive method you mentioned to upload files to sharepoint.

VJ04 · Answer

How do I upload files to sharepoint by preserving the template design. The one drive approach isn't working on server.

JoeS · Answer

As above, this definitely sounds like a great use case for Alteryx.

Download multiple files using the download tool

Combine the files using the dynamic input tool - (removing the 26 rows along the way)

Upload to SharePoint with our connector here - https://gallery.alteryx.com/#!app/Sharepoint-Files-Tool/6115a9c4826fd30fa4c434ad