I have a UI automation flow that generates a bunch of CSV files nightly. I'd like to automatically have these CSV files uploaded to a Microsoft Teams site without the use of OneDrive. What is the best way I can achieve this?
Reason I can't use OneDrive is that currently my RPA bots are using an RDS server that is heavily locked down and OneDrive cannot run on this server. Also, OneDrive will only synchronize while the user is logged in which might not work if the bot immediately is signing out after finishing the job. I considered a mapped drive to a Teams/SharePoint site, but this is a legacy feature.
So now I'm at the point where I have the PAD flow email the CSV files as attachments to a mailbox so that a cloud flow can trigger and run.
There has to be a better way?