How can you create a flow to update a sharepoint list, daily, with information from an excel workbook that is sent to me as an attachment in an outlook email?
In other words, I have created an app in Powerapps to display my sales reps' goals and tracking numbers. It allows them to see their sales numbers and rankings, in a user friendly format, on their phones/ tablets. The app is linked to and populated by an excel table that I manually update every morning on my Onedrive. The information I use to update the table with comes from an excel workbook that is sent to me as attachment on an email every morning around 3 am. Although it is not that time consuming to copy and paste, I would like to automate this process, if possible.
So the flow would look like this -
I get an email at 3 am with an excel attachment. I need the information in the excel attachment imported/added to a Sharepoint list that will be linked to Powerapps.
Can someone help?