Extract data from excel file uploaded to Sharepoint and create email

[Anonymous]

Hello,  

    I am wanting to upload an excel file to SharePoint and then generate an email that will contain a template referencing some of the data in the excel file that I upload to SharePoint.

Thanks for any info to get me started 

[sumurthy]

I think you can use this idea for referencing the data in Excel file. 

https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Select-overdue-items-from-Excel-worksheet/i...

For uploading a file, you can use create-file action on SharePoint or OneDrive. 

Thanks 

[Anonymous]

I will be uploading the same formatted excel document (different data) to SharePoint everyday. The issue I am running into is that how do I reference an excel file on my flow that I have not uploaded yet (future uploads). I would like my flow to go as followed:

Upload excel document to SharePoint-->Extract data from that excel file-->Use that data to create an email

Every time I have created a flow it ask me to reference an excel file and would like to know how to reference the most recent upload. Hope this makes sense

Thank you,

T