Jul 21 2021
11:30 AM
- last edited on
Aug 03 2023
06:53 PM
by
TechCommunityAP
Jul 21 2021
11:30 AM
- last edited on
Aug 03 2023
06:53 PM
by
TechCommunityAP
Jul 21 2021 01:32 PM
@dawny1911 you would have to do this with a flow in Power Automate. For the IT ticketing system at my company we send an email, back to the responder with the info they submited in the form, a reference number and other inforation. We just put this in the email but in the flow you could create a PDF and send that as an attachment.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Jul 21 2021 01:54 PM
Jul 22 2021 05:22 AM
@dawny1911 an example of a flow to send an email with a PDF attachment of the answers from a form is as follows:
In Power Automate create a new instant cloud flow then click skip on the next screen - I always like to start from a completely bland flow.
The trigger is a Forms when a new response is submitted and, as always, is followed immediately by the first action which is get response details. You might not need the following 2 actions to convert the date into UK format.
The next action is a OneDrive for Business create file. In this example I've selected for the filename one of the answers in the form which is a car license plate. You need to follow the filename with .html
For the content of the file add text and the questions from the get response details section of the dynamic content box. YOu can add html tags to add line breaks and other formatting.
Next add a a OneDrive convert file using path and select Path from the dynamic content box on the right. Your target type should be PDF.
Assuming you want to keep a copy of the PDF you next add another OneDrive create file action, selecting Filename and File Content from the convert file using path section of the dynamic content.
Finally add a send an email (v2), enter the email address it should go to in the To field. Add some text into the subject and body. Open the advanced options and for the attachment Name and Content fields select File name and File content from the convert file using path section of the dynamic content box.
..and the content of the PDF looks like this:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Jul 22 2021 08:33 AM
Jul 22 2021 09:09 AM - edited Jul 22 2021 09:25 AM
It won't let you test it from the Test menu until you have run it from a submitted form at least once. After that you can use the Test link.
The / puts the html and pdf files in your root OneDrive folder. I've found that works better than somewhere deep inside OneDrive, but you could try a different folder.
Jul 23 2021 03:51 AM
Jul 23 2021 03:57 AM - edited Jul 23 2021 04:00 AM
@dawny1911 you can't copy & past for images due to the way they need to be encoded in the flow. See my post here for how to add an image.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Jul 23 2021 07:40 AM
Jul 23 2021 07:46 AM
Jul 26 2021 03:42 AM
Jul 26 2021 03:44 AM
Jul 26 2021 03:47 AM
Jul 27 2021 07:21 AM
Jul 29 2021 03:36 AM
@dawny1911 either replavce the width = with height = or add in a height="150px" before the < closing tags
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Aug 20 2021 03:01 AM
Nov 09 2021 02:24 AM
Nov 09 2021 05:55 AM
@dawny1911 no, you can't stop this, it's programmed that way by Microsoft.
Rob
Los Gallardos
Microsoft Power Automate Community Super User