Converting List Item with Image column to PDF

[felixthecatx]

Hello, 

I am trying to convert individual SharePoint list items to PDF. I am formatting objects into an HTML format before converting to PDF. The problem I am having is the thumbnail objects associated with the image column. All of the other dynamic objects associated with the other columns transfer fine. 

Can anyone suggest how I should initialize, format the image object into html? 

Picture variable is 

decodeBase64(outputs('Get_item')?['body/{Thumbnail}/Large'])

Thank you! 

[v-bofeng-msft · Accepted solution]

Hi @felixthecatx ,

Do you want to get the content of the image in the image field?

If so ,I've made a test for your reference:

1\My list

2\The flow

1)

_api/Web/Lists/getByTitle('<list name>')/items(<Listitemid>)/?$select=<image_column_name>

2)

json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['d']['ImageColumn'])

3)

skip(outputs('Compose')['serverRelativeUrl'],nthIndexOf(outputs('Compose')['serverRelativeUrl'],'/',3))

3\Result

Best Regards,

Bof

[felixthecatx]

Hi @v-bofeng-msft,

To answer your question, if getting the image content will allow me to transfer it to html then that is what I am after. I'm trying to implement your solution but wanted to ask about the File Path statement. Where do I find the 'serverRelativeUrl' ? Is that something I need to find, or can I just use the statement you posted? 

Thanks for your input

[v-bofeng-msft]

Hi @felixthecatx ,

You could try my flow first , if there is any problem you could follow this post.

Best Regards,

Bof

[felixthecatx]

Hi @v-bofeng-msft ,

The flow is returning a bad request at the send http request to sharepoint stage. 

"The field or property 'Photo' does not exist."

The column does exist in my list. Do you have any ideas why it is not recognizing it? 

[felixthecatx]

Hi @v-bofeng-msft ,

I fixed the bad request, and the output of 'Send an HTTP request to SharePoint' is locating the correct picture. However the file is not being found in the 'Get file content using path'. I'm assuming this is due to a problem in the Compose step. The line I have in Compose is 

json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['d']['Image'])

Are there any further thoughts or resources you can direct me to? I'm hoping Microsoft establishes functionality for the Thumnail objects for this column soon...

Thanks

[Anonymous]

Hi @felixthecatx 

I am facing similar problem. Have you solved this problem yet?

[ejp]

Hi, need help with my flow. My list has a column hyperlink column that changes the image based on what is selected in another column. I now need to pull the item information including that image to a pdf. I have the pdf information working fine but can't work out how to get the image to show. Any help would be greatly appreciated.