Answered

Flow generate a pdf report + photos

(0) Share

Report

Posted on by ProFe

Hi guys,

I have a simple flow: a user fill a Sharepoint form, each answer is written in an html table and the html document is converted in pdf. Everything work fine, but I want my user to take a photo for a few questions. Photos will be saved in an "attachment column" in sharepoint.

How can I display these photos or attach them to my report ?

Thanks for your help

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

eliotcole 4,390 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you don't already know the Attachment ID, then Get attachments > Get attachment content, if you do, then Get attachment content ...

Once you're there, then either make the file temporarily somewhere on a drive to perform what you're already doing, or insert from the attachment content.

I don't know how you're currently making the HTML, so y'know ... which ever of those works. 👍

Was this reply helpful? Yes No
ProFe on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer,
I made it simple: my flow is working when I attach one image, but I need my user to upload 2 or 3 photos.

Do you have any advices for that ?

I'm trying to work with one "Image" column per question, but working that way I can't make use of the "get attachment content" action.
See below my flow. working with 1 attachment:

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @ProFe ,

Please try:

concat('<img src="data:',body('Get_attachment_content')['$content-type'],';base64,',body('Get_attachment_content')['$content'],'" width=100% >')

Best Regards,

Bof

Was this reply helpful? Yes No
ProFe on at

Like (0)

Report
Copy link

Link copied!

Thank you for your help, it's working but I chose another solution since I have a 2Mb limitations for converting file to pdf.

Was this reply helpful? Yes No
Devlink 16 on at

Like (1)

Report
Copy link

Link copied!

Thank you sooooo much! I've been trying to work out how to do this for three days! As a JSON and PA noob it was proving to be a never ending circle failures, but this worked first time 👍🏻

Was this reply helpful? Yes No