sharepoint list get item to html

Like (0) Share

Report

Posted on 16 Mar 2022 07:25:28 by Matt383

395

Hi, I have a sharepoint list and i want to be able to select an entry and extract all content from that one entry into html. I have created a flow in the sharepoint list (See Flow2 img) and tried using compose to replace text in the html i uploaded, with the data from the sharepoint list. (See Flow1 img) The flow works with no errors, however not all the content comes across. Some data goes into the html and others just keep the original text in the html. I have tried changing the html with tokens around the text (e.g. {Sitehere} ) However, results in the same outcome. Any help with this would be much appreciated.

Flow2.PNG

Flow3.PNG

Flow1.PNG

All responses (4)

Answers (1)

Matt383 395 on 18 Mar 2022 at 03:59:38

Like (0)

Report

Re: sharepoint list get item to html

Cheers, that will work as well, i will test it over the weekend.
Verified answer

Ashwin7104 671 on 18 Mar 2022 at 03:54:26

Like (1)

Report

Re: sharepoint list get item to html

Hey @Matt383,

How about we generate the HTML content directly in set variable action instead of replacing each text using compose action with actual value.

The variables you see on the above images either contains image base 64 value or it contain data as well. Then the HTML variable is used to generate PDF. Will this method work for you ?
Matt383 395 on 18 Mar 2022 at 03:09:52

Like (0)

Report

Re: sharepoint list get item to html

Hi v-bofeng,
Yes i have all the images converted to base64 and have checked numerous times on the compose, even side by side with the ones that do return the data. No errors in the flow, numerous efforts to resolve this with same results. In the end, modified flow to initalize variable (Name: objectList, Type: Object, Value: Body), then a Compose with html script in expression.
<td>',variables('objectList')?['WorkDetails'],'</td> returns all the data. In regards to images, this worked for me
<td><img src="',variables('objectList')?['Signature1'],'" width="60" height="60"></p>

Cheers,
Matt383
v-bofeng-msft on 18 Mar 2022 at 02:40:26

Like (0)

Report

Re: sharepoint list get item to html

Hi @Matt383 :

I suggest you to check that each compose action correctly references the return result of the previous compose. Also, I recommend you to check the output of each compose in the run history.

In addition, if you wish to display images in HTML I suggest you use Base64 images.

Best Regards,

Bof