Can an excel export of a filtered view be emailed daily?

Question

I regularly need to export a filtered view to excel. Is there a way to schedule this as a nightly delivery? I know I can set up a subscription but I need an actual excel file (Export Excel CSV (filter fields)).

I have a power automate rule set up that will take excel email attachments and upload them to my sharepoint, from which PowerBI regularly updates. This would save me from having to manually download and then drop it to sharepoint, overwriting the previous file.

cox.tw · Answer

@Aron Gombas _Midori_ Pretty much. Safeguarding confidential data, etc. I can't even use APIs to connect Jira to other approved applications!

Aron Gombas _Midori_ · Answer

@cox.tw What is the reason your admins are reluctant to install apps? (Security?)

cox.tw · Answer

@Aron Gombas _Midori_ - Good to know, though I highly doubt our admins will allow the install. I requested it but have little hope. :)

Seems like such a basic use case.....I'm surprised this isn't offered outright.