You are the best. Spending a lot of time trying to figure out the shortened URL issue and this 12 min video solved it all. There are a lot of videos out there but you are gifted at explaining clearly and easy to understand.
You're a life saver! This is the best tutorial: Clear, gives a lot of context to help understand why the system does what it does, and easy to follow! Thanks to you, my flow now works like a charm! Thank you so much!! Subbed!
Thanks for posting this Ben. I spent way too much time trying to get my href code to work. Power Automate kept injecting HTML code and messing it up. Defining the Href as a variable worked great.
Thanks Ben. Is it crazy to think that with PA you could create an initialize variable action to get an email address from a table (which has many customers with emails and amounts of business done with us last month) and then when you click on that link in your email, it would be able to bring up an Outlook message with the email address in the TO field with a pre-defined subject and text in the body - say I wanted to thank someone for their business?
Very possible! That actually not too difficult to do. Here’s what your link would look like (more or less): Send Email With this, you can see the “email@example.com” would be the customers email or the variable. Then, after “subject=“, that will be the subject. %20 and other symbols are spaces and other special characters, as the message needs to be “encoded” because it’s technically a link. Finally, “body=“ will be the body of the email message. :) Of course, you can replace any of this message with the dynamic content from your flow! If I didn’t explain this well enough let me know and I’d be happy to explain it better. You can also email me at ben.fetters@sovereignsp.com
So how could I incorporate this into a manually triggered action to send a link to a file. For example I want to send a link referencing a doc in Site A then later send a link referencing a Excel sheet from Site B. Can I use the same script? or would I have to create scripts fro each site?
Great Video and super easy to follow! However, I my Power Automate isn't giving me the formatting options in the body of my email. Do you know why this would be? All I can see is one button "Switch to HTML View" and even that one is grayed out. Thanks!
Nice! What happens if my URL I am building has spaces in it? Perhaps I have multiple fields I want to use to dynamically build the URL. Can I write the multi-field URL to a variable then encapsulate the whole variable in a uriComponent() expression or do I have to encapsulate each individual field in a uriComponent() expression when defining the variable? When I try the former I get strange entries in the URL...like div tags... Secondly, that editor in the "send an email" action totally screws up my html code if I re-open that action later after saving the flow. I find I have to copy the html code and save as a text file offline just to preserve all of my html code in "send an email" actions. If I ever need to make a change, I have to copy/paste the code back in, make changes and then remember to save another copy of my html code offline again. Very frustrating that it won't leave my editor in "code view" mode and messes up my specially crafted URL when it does this.
Hi, not sure if you're gonna see this in time - I have an image that has a button on it that says "Click Here". By watching your video, I learned how to put a hyperlink in a power automate email but I need to send an email with an image with the hyperlink in the image specifically on the button that says "Click Here". Do you know of any way to do that?
Can you create a variable that has a list of links? I tried using "Apply to each" but didn't let me. I'm taking attachments from a form response (already parsed in JSON), but now trying to either attach them or simply add a list of those hyperlinked attachments to the email body. Open to ideas and resources.
Hi Ben I have one issue when receiving email some text have hyperlink integration with the text! Are there any way to receive the email remove any hyperlinks converting it to simply text so I can use it to be resent to others with out hyperlinks in the text
Is there any workaround if I receive a downloadable link in Outlook and then to open it (save it) in certain folder? Or if you know some links where I can find it. Thx
You are the best. Spending a lot of time trying to figure out the shortened URL issue and this 12 min video solved it all. There are a lot of videos out there but you are gifted at explaining clearly and easy to understand.
I don't know why I am just seeing this but thank you so much! Glad it helped :)
Spent a week figuring out links in Power Automate and this is the only solution that worked. Thank You!!!
Essentially the same solution as many other written examples except this one made sense!!! Thank You!!!
Huzzah! Glad it helped!
You're a life saver! This is the best tutorial: Clear, gives a lot of context to help understand why the system does what it does, and easy to follow! Thanks to you, my flow now works like a charm! Thank you so much!! Subbed!
Yay! That's the best thing to hear. So glad it helped! :)
This was super helpful to me, super late at night and just what I needed. Thank you!!
Thank you, implemented, tested and working. This will make life much easier.
Saved me after 3years...great
This video is really very helpful Ben to automatic ADF pipelines Email notification
Thanks for posting this Ben. I spent way too much time trying to get my href code to work. Power Automate kept injecting HTML code and messing it up. Defining the Href as a variable worked great.
Thank you! this sorts out my power automate flow - very helpful!
thanks for the sharing:-)
Easy to follow! Thanks for the video.
You bet, glad you liked it!
Great Video - helped a lot! Thank you very much 🙂
This video is very help full for me in one of my project so thank you🙂
Super helpful, thank you so much!
Does a dynamic content from MS Forms work with this? Great Video!
This is sooooo useful!!! Thank you so much!
Thanks!
Works perfect! Thanks!!
This video is really very very helpful Sir, please upload more videos on the power apps & power automate
Great video sir, thank you for this
Thanks heaps, mate.
You bet, glad it was helpful!
thank you! super helpful
Thanks Ben. Is it crazy to think that with PA you could create an initialize variable action to get an email address from a table (which has many customers with emails and amounts of business done with us last month) and then when you click on that link in your email, it would be able to bring up an Outlook message with the email address in the TO field with a pre-defined subject and text in the body - say I wanted to thank someone for their business?
Very possible! That actually not too difficult to do. Here’s what your link would look like (more or less):
Send Email
With this, you can see the “email@example.com” would be the customers email or the variable. Then, after “subject=“, that will be the subject. %20 and other symbols are spaces and other special characters, as the message needs to be “encoded” because it’s technically a link.
Finally, “body=“ will be the body of the email message. :)
Of course, you can replace any of this message with the dynamic content from your flow!
If I didn’t explain this well enough let me know and I’d be happy to explain it better. You can also email me at ben.fetters@sovereignsp.com
Thanks,
still relevant ;)
That piece of random gibberish you removed is actually a HTML code for "space" :D
So how could I incorporate this into a manually triggered action to send a link to a file. For example I want to send a link referencing a doc in Site A then later send a link referencing a Excel sheet from Site B. Can I use the same script? or would I have to create scripts fro each site?
Hello! Great video, I was able to change the link's display. I have a doubt, is there a way to add the link to an embeded image?
Great Video and super easy to follow! However, I my Power Automate isn't giving me the formatting options in the body of my email. Do you know why this would be? All I can see is one button "Switch to HTML View" and even that one is grayed out. Thanks!
This method does not work for "Apply to each" ?
I think so, i also can't retrieve the variable
Great video. Does it work with a SharePoint attachment via a Microsoft Form? I am using the 'when a new response is submitted' flow .Thank you
Nice! What happens if my URL I am building has spaces in it? Perhaps I have multiple fields I want to use to dynamically build the URL. Can I write the multi-field URL to a variable then encapsulate the whole variable in a uriComponent() expression or do I have to encapsulate each individual field in a uriComponent() expression when defining the variable? When I try the former I get strange entries in the URL...like div tags... Secondly, that editor in the "send an email" action totally screws up my html code if I re-open that action later after saving the flow. I find I have to copy the html code and save as a text file offline just to preserve all of my html code in "send an email" actions. If I ever need to make a change, I have to copy/paste the code back in, make changes and then remember to save another copy of my html code offline again. Very frustrating that it won't leave my editor in "code view" mode and messes up my specially crafted URL when it does this.
Hi, not sure if you're gonna see this in time - I have an image that has a button on it that says "Click Here". By watching your video, I learned how to put a hyperlink in a power automate email but I need to send an email with an image with the hyperlink in the image specifically on the button that says "Click Here". Do you know of any way to do that?
Can you create a variable that has a list of links? I tried using "Apply to each" but didn't let me. I'm taking attachments from a form response (already parsed in JSON), but now trying to either attach them or simply add a list of those hyperlinked attachments to the email body. Open to ideas and resources.
me too. Do you have any solution yet ?
Great!
Hi Ben I have one issue when receiving email some text have hyperlink integration with the text! Are there any way to receive the email remove any hyperlinks converting it to simply text so I can use it to be resent to others with out hyperlinks in the text
How can I add an unsubscribe link to my HTML template?
Hi, Can you help me Using Power Automate In Outlook Email how to click a link to download the file attached.
Is there any workaround if I receive a downloadable link in Outlook and then to open it (save it) in certain folder? Or if you know some links where I can find it. Thx
Hi, is possible to create a link in the email to update the sharepoint list item when is clicked?
@@sovereignsp Thankyou for your answer, i finally used a flow to update my item in SharePoint, sending an approval request 😉
Helped.
Thank you for this! The html one places directly in the Send an Email action is still getting jarbled. This method is way more clean.
how about getting a file from a link
In simple words convert the text to basic text without any format or hyperlinks in it
Very very confusing!
your video quality is not good enough to understand