Unanswered

Create an email button on Excel using Power Automate?

(1) Share

Report

Posted on by zukazuka

I actually have been able to create a flow on Power Automate that I can then attach as a script to a button on my Excel sheet to send an email of the form when clicked.

However, I want to embed that excel file onto my website and allow users to make necessary changes that would then be emailed by clicking on the button. The issue that I am encountering is instead of emailing a copy of the excel file that was modified on my website, it will instead email the original file that is located on my OneDrive, which would not contain any of the new edits.

Is there a way for me to redirect the flow to download the edited file that is on my website instead of the original file that is on my OneDrive?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

@zukazuka

Sigh, what flow?

Please use pictures etc of the flow, the actions etc, And annotate so we know where a question is about. please don't just typea description.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
zukazuka 2 on at

Like (0)

Report
Copy link

Link copied!

Sorry, this is my first day learning what Power Automate even is, so my knowledge is as close to 0 as you can get. I barely know even to even form a question.

This is the flow that I have. At the moment, it gets the worksheets from my OneDrive folder.

I have the same worksheet embedded as an iframe on my webpage, which can be seen as an example HERE

I realized that the edits being made on the excel file embedded on my webpage is not being saved, due to the nature of how iframe works, which lets users edit the file without saving. This part actually works perfect for my application.

I need to create a similar flow to the one that I have, since I want to be able to assign a button to run the script. The main difference is that I will need it to email me the user edited excel file that is embedded on my webpage and not the original file that is stored in my OneDrive folder.

Example of original file:

Example of the file after a user makes their edits:

Was this reply helpful? Yes No