Hello everyone,
I'm working on a canvas app for service reports. Part of the report should be images of broken/fixed machine parts.
Images and image description as well as other "meta data" are saved in a Dataverse table.
I would like to create a flow which makes an Html table (and later conversion to PDF) with 4 columns (Created on, WorkOrder Number, Image & Image description) and a dynamic number of rows, obviously depending on how many pictures our service engineer takes.
I have read that I might need to do some base64 conversion of the Images, but all instructions I have seen are only about static images like a company logo in the corner and are not really helpful to my dynamic table problem.
Also I'm not sure if my src URL to the Image column is even correct.
Name of table :Photostable
Name of column: NewImage
Any clues or tips would be appreciated.
P.S. The HTML text below is what I'm using to create the table.
"<h3><font size = 3> Report Images </h3>" & "<strong></strong>" & "<table width='100%' border='1' cellpadding='3' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'>
<th width='10%' align='left'><font size = 2> Created on </th><th width='10%' align='left'><font size = 2> WO Number </th> <th width='20%' align='left'><font size = 2> Image </th><th width='5%' align='center'><font size = 2> Description </th>
</tr>
<tr>" & Concat(
Sort(
Filter(
Photostable,
'Case ID' = 'Open Cases Gallery'.Selected.'Case ID'),
'Created On',
Ascending
),
"<td> <font size = 2>" & Text(
'Created On',
"[$-en-GB]yyyy-mm-dd"
) & " </td>
<td> <font size = 2>" & 'Work Order Number' & " </td>
<td align='center'> <img src=GET xXxXxXxX.com/api/data/v9.1/crbdf_photostable(42c1464f-f7cc-eb11-bacc-000d3a2257ad)/crbdf_newimage/$value?size=full/</td>
<td align='center'> <font size = 2>" & 'Description of photo' & " </td>",
"</tr><tr>"
) & "</table>"
