You’re offline. This is a read only version of the page.
8
Hell everyone!
I'm really new to Power Automate and have figured out some pretty basic stuff but I'm trying to figure out how to clean up the body of the email that is sent when a form response is submitted. I've got all the dynamic content in there and it looks okay (except the attachments those are a mess) but the emails themselves look super bland and wanted to know how to spice them up and instead of showing the URL for the attachments (which are long and mess) instead show the file name and type as hyper links. or just arrive in the email as an attachment themselves.
I have spent countless hours searching the internet to find this answer and I've had no luck what so ever. Hopefully someone can help me with this.
Currently the flow is
When a new response is submitted
Get Response Details
Send an email (V2)
Hi @RobElliott no worries at all, I just wanted to check in to see if you did I also understand the holidays would be a busy time for you as well. 🙂
Sorry, work pressures mean I haven't had a chance to look at this yet.
Morning @RobElliott and happy new year. Just wanted to check in to see if you had any further thoughts on this. Thanks again for all your help!
Yeah, I watched a video showing how to do a form, that saved all the submission to a list, along with the attachments being saved to a SharePoint document folder and then they added in email submission at the end but when I tried to skip the list because we don't need it, it would fail.
@KIlJhard you can't just add the "Attachments" dynamic content from the form and expect the files to get attached or displayed. It doesn't work like that. Your flow needs to save each one into OneDrive and then get the file name and content. You've made life more difficult for yourself by allowing multiple files to be uploaded on the same question, it works much better with just 1. I'll look at the best way of dealing with that tomorrow but it will need a few more actions before you can achieve what you want.
Rob
Los Gallardos
@RobElliott
Hi Rob, so I'm not knowledgeable about HTML either. lol but unfortunately I'm not using SharePoint to save the files. The attachments are uploaded to Microsoft Forms and when the form is submitted they are automatically saved to OneDrive. I tried using the "Get File Content using Path" for OneDrive but it was just coming back with failures so I went back to using the Dynamic Content with Forms.
I've attached a pic of the flow. It's really basic because I'm crash coursing myself with Power Automate but once its all done its being handed off to someone else to take over everything so I'm also trying to keep it simple for them as well. 🙂
Attached a pic of the form and as you can see any file can be uploaded and then a pic of the flow which I don't think you can get any more basic than that.
@KIlJhard in the toolbar at the top of the email body click the code view button </>. You can then use html tags to make your email look really nice, add proper links, images, tables etc.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
