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
