Monthly Repeat Email Flow with Attachments

[Gareth]

Hello,

Not sure if this is possible. I currently collect data from a group of clients at the end of each month. Where I send them an email with the attachment. They populate this and send it back. As a team, we use Power Bi for a group overview of performance. 

Is it possible to create a flow to:

- send an email on the last working day of each calendar month as a reminder to each person. The email holds an excel attachment.

- on receipt of the email, save the attachment to a Sharepoint Site

- The data from the excel spreadsheet, populate the PowerBi workflow

This would save me around 2-3 days of work each month in automation of the process.  I may be dreaming about this, but got excited when I've started to explore Flow's potential.

Any help is much appreciated.

Thanks,

G

[Leo09]

Pretty sure that steps12 can be achieved but PowerBI part, I think it is not possible so far.