sharepoint to pdf flow Image showing broken

Like (0) Share

Report

Posted on 26 Sep 2022 22:43:23 by Matt383

395

Hi, i have a jobcard app. When they submit the information, goes to a sharepoint list, then a flow (when item created in sharepoint) that converts the data into a pdf. In the flow, i have a compose with html (e.g concat('<!DOCTYPE html>
<html>
<h3>JobCard</h3>
<p> </p>
<div>
<td style="width: 139.5px;"><img src="',variables('objectList')?['Signature1'],'" width="80" height="80" /></td>
<table style="height: 117px; width: 580px; float: left;">
<tbody>)

The problem i have, is if someone doesn't enter a signature, it shows a broken link in the pdf

I have a blank image called Image10. I just need to replace Signature1 with Image10 if no signature is entered. Can you please assist

All responses (2)

Answers (0)

Matt383 395 on 26 Sep 2022 at 23:04:01

Like (0)

Report

Re: sharepoint to pdf flow Image showing broken

Thanks. So just to clarify, would replacing
<td style="width: 120.3px;" colspan="2"><strong><img src="',variables('objectList')?['Signature1'],'" width="60" height="60" /></strong></td>
with
<td style="width: 120.3px;" colspan="2"><strong><img src="',variables('objectList')?['If( Not IsBlank( Signature1 ), Signature1, Not IsBlank( Image10 ), Image10 )'],'" width="60" height="60" /></strong></td>
work?
RandyHayes 76,287 Super User 2024 Season 1 on 26 Sep 2022 at 22:47:33

Like (0)

Report

Re: sharepoint to pdf flow Image showing broken

@Matt383

You can use the coalesce function to do so. Not sure of your entire flow (and this forum is focused on PowerApps and not PowerAutomate), but investigate the coalesce function and you can implement that into your flow.

Coalesce will return the first parameter which is not blank. So in your case, it would be a Coalesce on Signature1 and Image10.

I hope this is helpful for you.