Creating a html file including the pictures saved in attachment column from a list

(0) Share

Report

Posted on by AOZ

110

Good day,

I am looking for a simple way of creating a html file (or pdf) which will contain the list items (this one is ok) along with (most important) the images which are saved inside the attachment column.

thanks.

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Unfortunately, to add the pictures to the HTML you'll need to retrieve the actual contents of the picture file. This video by Shane Young is probably one of the best overviews of what to do.

https://www.youtube.com/watch?reload=9&v=2rfAQe1kK8M

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Hi @AOZ

I believe it is possible to use the attachment images. I also agree that the Shane Young Video is good. @RezaDorrani has a good one too https://www.youtube.com/watch?v=Da4do2DxmJE.

I have tried the following:

Retrieve the attachments from the list Item (using the Item ID), then in an apply to each, I get the file content of each file and output to a compose.

Outside of the Apply to Each, I then use "Pieters Method" to bring together an array of the file contents using a compose.

A select is used to create an array of HTML IMG tags using the DataURI expression.

I join the array using a select action with BR tags to insert some break lines between images (html formatting of your choice at this point ! 😉 )

A compose to insert the img html into the main HTML

And then finally a create file action to create the HTML file.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
AOZ 110 on at

Like (1)

Report

Indeed @RezaDorrani 's video allowed me to do it successfully!

Was this reply helpful? Yes No
mmunday 16 on at

Like (0)

Report

What was the expression used in the select area

Was this reply helpful? Yes No
mmunday 16 on at

Like (0)

Report

do you have a link to that video

Was this reply helpful? Yes No
mmunday 16 on at

Like (0)

Report

I was able to follow your instructions which are perfect. I ran into an issue. My SharePoint item has 5 attachments but only 3 are displaying on html file. What did I do wrong?

Was this reply helpful? Yes No