PDF Attachment - Send an email

(0) Share

Report

Posted on by Tobia

Hello,

I'm creating a flow which grabs the outputs of a MS Form into a PDF then emails this as an attachment.

To achieve this, I have done the following:

Created a HTML template then replaced the answers with some set variables to look for
Converted the HTML doc to PDF using OneDrive

All of this process works fine aside from one small issue, when the document is emailed I can't see the image I have put in the template but within the file save within OneDrive this is present.

I am using the Send An Email (V2) option to send the email out.

I saw on some other forum about adding a delay, but this didn't make any difference

Any ideas?

HTML Code

Submitted by: {Submitted}

IT Asset Accident/Incident Report

User

First name: {First}

Surname: {Surname}

Device

Affected IT device/equipment: {Affected}

Serial number of affected device/equipment: {Serial}

Current status/functionality of the affected IT device/equipment: {Current}

Situation

How the accident/incident happened: {How}

What steps have been taken to prevent a reoccurrence in future: {What}

Flow

Cheers

Tobia

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-chengfen-msft on at

Like (1)

Report

Hi @Tobia ,
The reason for this problem is:
1. Images in URL form cannot be accessed due to restrictions
Please try using image content:
Here is a Test for your reference:
Images submitted by users in Forms are saved in the App folder of OneDrive.
We can get the content and detailed information of the picture through [Get file content using path] and [Get file metadata using path] and the picture name.
[Prase JSON] Schema:
{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "name": {
                "type": "string"
            },
            "link": {
                "type": "string"
            },
            "id": {
                "type": "string"
            },
            "type": {},
            "size": {
                "type": "integer"
            },
            "referenceId": {
                "type": "string"
            },
            "driveId": {
                "type": "string"
            },
            "status": {
                "type": "integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}
Here is result:

Here is a link for your reference:
Solved: How we can use Libraray image in Powerautmate flow... - Power Platform Community (microsoft.com)
Best Regards
Cheng Feng

Was this reply helpful? Yes No
Tobia 16 on at

Like (0)

Report

Hi Cheng,

Tried to modify this to make it work with my setup as it slightly differs
The user doesn't submit the image, the image is already pre done by myself and is just a logo i would like on the PDF

I have changed my image to this

<img src="{JPG}" width="321" height="68" />
 
Submitted by:
{Submitted}
 
IT Asset Accident/Incident Report
 
User 
First name:
{First}
Surname:
{Surname}
 
Device
Affected IT device/equipment:
{Affected}
Serial number of affected device/equipment:
{Serial}
Current status/functionality of the affected IT device/equipment:
{Current}
 
Situation
How the accident/incident happened:
{How}
What steps have been taken to prevent a reoccurrence in future:
{What}

How would i change the {JPG} to the logo i have stored in onedrive
I have tried to use the replace(GET-FILECONTENT OF ONEDRIVEFILE,{JPG},FILENAME) but couldn't get this to work.

Cheers

Tobia

Was this reply helpful? Yes No