Power Automate
Budget: $10 – $30 USD
I receive the attached sample file as an email attachment every day. I would like to put to automatically generate a dashboard from this attachment, which gets automatically updated on a daily basis. Power Automate and Power BI can be used - or a straightforward excel data connection from a dashboard in an excel file to this file in the same folder.
Key Conditions:
1. Remotely do the power automate flow design on a Zoom session on my system
2. Number of rows in each sheet in the report is variable - number of columns is fixed
3. Combine all the rows in each sheet of the report into a single unified table and the dashboard to be updated dynamically
4. Flow to be triggered when new email arrives each morning
Key Conditions:
1. Remotely do the power automate flow design on a Zoom session on my system
2. Number of rows in each sheet in the report is variable - number of columns is fixed
3. Combine all the rows in each sheet of the report into a single unified table and the dashboard to be updated dynamically
4. Flow to be triggered when new email arrives each morning