It would be great if scheduled reports with a CSV would send the file as an attachment instead of a link to download the file. Currently, if PDF is selected the PDF file will be attached, but if CSV is selected it sends a link that must be clicked to download the CSV file. (If both are selected it will attach the PDF but link to the CSV file.)
My problem is that I’m trying to automate something, using Power Automate, and when I try to download the CSV from power automate it downloads the login screen instead of the CSV file. There is a way, using power automate, to download an attachment from an email. This enhancement would make it possible for me to automate the user creation from start to end: Send a daily report of new hire tickets as a CSV, download the attached report, process the CSV getting the information I need, create the user, and notify the correct people. All with absolutely no interaction. Without this, I need to manually download the file before the rest of the process can kick off. (Or pay for Power Automate Premium so that I can interact with the API via HTTP requests.)