Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extract data from excel file uploaded to Sharepoint and create email



    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 


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


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



Not applicable

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,

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,416)