-
Inquiry on Automating Email Reconciliation via excel and Power Automate
Dear Power BI Team,
I hope you’re doing well.
I’m reaching out to inquire whether it’s possible to reconcile emails using an Excel spreadsheet. I’m exploring ways to reconcile emails in an Excel spreadsheet-ideally by using Outlook. Specifically, I’d like to know if we can upload and Excel file to SharePoint or Power Automate and have it automatically populate the Excel file with information on when the emails was responded to and by whom. Example attached.
The goal is to streamline a process where incoming emails are matched against data in the Excel file-ideally automating this workflow without manual intervention.
Could you please advise if this feasible with the current Power BI and Power Automate capabilities. If so, any guidance or best practices would be greatly appreciated