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
Solved! Go to 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
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
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
Hi @felixthecatx ,
You could try my flow first , if there is any problem you could follow this post.
Best Regards,
Bof
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?
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
I am facing similar problem. Have you solved this problem yet?
User | Count |
---|---|
88 | |
39 | |
23 | |
20 | |
16 |
User | Count |
---|---|
129 | |
50 | |
48 | |
35 | |
26 |