cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Upload Excel using Form --> List the excel rows in that file --> Send email

Hi Community,

Is there a way to have this requirement worked

Upload Excel using Form --> List the excel rows in that file --> Send email with row value in the body

 

 

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Hi, could you provide more details about this? like a screenshot. Thank you.

Highlighted

Thanks Rei for helping.

My requirement is this.

1. Using MS Form to upload an excel file. once the file is uploaded the flow gets triggered. the excel file has a predefined Table Name with following column. The idea is that users should use that excel file as template to submit the list of user and email address. 

PowerO365Guy_0-1601302242161.png

 

2. Then using the Power Automate i want to list the rows of the excel file and update in a SharePoint list. 

The catch is when users submit the excel file its name changes. I am trying to fine a way to use  "list the rows" excel connectors but its not working as the excel file name changes. 

 

Highlighted

PowerO365Guy_0-1601305955184.png

I get the excel file from MS Form --> creates it in a seperate folder --> But i am unable to use list the rows because the File path has to be selected priorly but i would like to have it dynamically.

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,648)