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

email responder with data submitted to excel from a form

I have an excel spreadsheet that is attached to a form.  Users enter the number of widgets and hours worked into the form and that information populates the excel spreadsheet.  In the spreadsheet, there is also a column that calculates the widgets per hour and a special weighted value for the type of widget.

 

I would like to have an email sent to the user when their new row is  added to the excel spreadsheet that includes what they entered and the calculations from that row. 

 

Can anyone point me in the right directions to create that kind of workflow if possible?  Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: email responder with data submitted to excel from a form

Hi @jnosko ,

 

There is similar request in the link below and hope it could be your reference:

https://powerusers.microsoft.com/t5/Connecting-To-Data/Email-link-with-the-Excel-data-that-contains-...

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: email responder with data submitted to excel from a form

Hi @jnosko 

 

This feature is not supported in Microsoft flow. There is no trigger when a row is added in Excel. 

 

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Community Support
Community Support

Re: email responder with data submitted to excel from a form

Hi @jnosko ,

 

There is similar request in the link below and hope it could be your reference:

https://powerusers.microsoft.com/t5/Connecting-To-Data/Email-link-with-the-Excel-data-that-contains-...

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Dual Super User
Dual Super User

Re: email responder with data submitted to excel from a form

Hey @jnosko 

 

You mentioned that there is a form attached to the excel sheet. Is it a Power Apps form? if so, you can set up a flow over there that is triggered on a button control (along with the submit button itself) and sends all the information needed. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (6,188)