Yeah, you can simply leverage a Scheduled Flow at the time you want to run it, grab the data, format it into either an attachment OR a very nicely formatted HTML table within the Email (which would be super easy if they do not mind that).
Attaching and doing all of that is easy enough, the only real work is taking the data out and formatting it how you want it.
By default all the data comes out in an Array, so you can literally
--use a Select to pick only the columns you want
--then either simply send this as your attachment content
-or
--turn it into a nice HTML table and email that or attach that as the content
Not really too bad, its just a matter of also knowing what you need as you initially said you had an App that created a Report. So that isn't something you "schedule" as its an App doing the work.
If you are now saying you do not need the App to send it, then yeah you would still build it mostly the same as i said, except instead of passing data from the App to the Flow, you are just using a SCheduled flow.
If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.
Thank you!
Sincerely, Michael Gernaey
