Answered

sharepoint list get item to html

(0) Share

Report

Posted on by Matt383

407

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Ashwin7104 671 on at

Like (1)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No