Re: Unable to generate a pdf from Flow

Anonymous · ‎11-27-2019

Hello All,

I'm trying to save my HTML to action in MS flows. However, once I test the flow, in the end, it shows it was a success but then shows an error on the UI. Unable to understand how to tackle this issue?

Can someone help me in this regards?

Gristy · ‎11-27-2019

looks like you have a expression error.

can you share the configuration of your action

v-litu-msft · ‎11-27-2019

Hi @Anonymous,

Could you expand your concat() function in the create File action? It seems like some error on that.

And it seems like the file is created successfully but the Flow report error, right? If possible, you can share the file with me.(Please shield personal information)

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

charlon_cabrera · ‎11-27-2019

Must be the file name avoid special characters and symbol, its actually plain and simple, below works just fine.

Tom_Slosse · ‎11-29-2019

Hey @Anonymous

Seems like you don't pass anything into your concat() function and thats why you get this error.

Like some of the other users suggested please post a screenshot of your expression concat()

Kind regards

Tom

If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Anonymous · ‎11-29-2019

Thank you for your response.

Below is my HTML that I've inserted in the Concat() function. It successfully takes it and when I run the flow till the end it shows me that there're no errors. As soon as it navigates back to the main page it shows an error. Please let me know where did I go wrong.

concat('<html>

<head>

<title>TRAILER INSPECTION SHEET</title>

<style>

<!--

/* Font Definitions */

@font-face

{font-family:Wingdings;

panose-1:5 0 0 0 0 0 0 0 0 0;}

@font-face

{font-family:"Cambria Math";

panose-1:2 4 5 3 5 4 6 3 2 4;}

@font-face

{font-family:Calibri;

panose-1:2 15 5 2 2 2 4 3 2 4;}

/* Style Definitions */

p.MsoNormal, li.MsoNormal, div.MsoNormal

{margin:0in;

margin-bottom:.0001pt;

font-size:12.0pt;

font-family:"Times New Roman",serif;}

p.MsoFootnoteText, li.MsoFootnoteText, div.MsoFootnoteText

{mso-style-link:"Footnote Text Char";

margin:0in;

margin-bottom:.0001pt;

font-size:10.0pt;

font-family:"Times New Roman",serif;}

p.MsoHeader, li.MsoHeader, div.MsoHeader

{margin:0in;

margin-bottom:.0001pt;

font-size:12.0pt;

font-family:"Times New Roman",serif;}

p.MsoFooter, li.MsoFooter, div.MsoFooter

{margin:0in;

margin-bottom:.0001pt;

font-size:12.0pt;

font-family:"Times New Roman",serif;}

span.MsoFootnoteReference

{vertical-align:super;}

span.FootnoteTextChar

{mso-style-name:"Footnote Text Char";

mso-style-link:"Footnote Text";}

/* Page Definitions */

@page WordSection1

{size:8.5in 11.0in;

margin:.6in 42.5pt 27.35pt 56.9pt;}

div.WordSection1

{page:WordSection1;}

-->

</style>

</head>

<span

style="font-family:"Arial",sans-serif">TRAILER/CONTAINER INSPECTION SHEET

<p class="MsoNormal" text-align=center style="margin-left:70.8pt;text-align:center;

text-indent:35.4pt">

<span

style="font-size:9.0pt;font-family:"Arial",sans-serif">NAME:_________________ DATE: __________ CARRIER: ____________ TRAILERNo. _______

<p class="MsoNormal" align=center style="text-align:center;border:none;

padding:0in">OE

SHIPMENTS

<p class="MsoNormal" align=center style="text-align:center;border:none;

padding:0in"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;

color:red">DO NOT LOAD OE SHIPMENTS ONTO REFRIGERATED TRAILERS

<span style="font-size:

9.0pt;font-family:"Arial",sans-serif">

<span

style="font-size:9.0pt;font-family:"Arial",sans-serif">If GM Shipment<span

style="font-size:9.0pt;font-family:"Arial",sans-serif">, record year of

manufacture (no older than 9 years 10 months) ________

<span style="font-size:

9.0pt;font-family:"Arial",sans-serif">

<span

style="font-size:9.0pt;font-family:"Arial",sans-serif">Plant Svc T<span

style="font-size:9.0pt;font-family:"Arial",sans-serif">: Water test completed

(if capable)? Yes / No / NA

</div>

</div>

<span style="font-size:10.0pt;font-family:"Arial",sans-serif;

background:yellow">Trailer ID<span style="font-size:10.0pt;

font-family:"Arial",sans-serif;background:yellow">:

<span

style="font-size:10.0pt;font-family:"Arial",sans-serif;background:yellow">Is

numerical identification clear and readable? Yes

/ if No <span style="font-size:10.0pt;font-family:Wingdings;

background:yellow">a<span style="font-size:10.0pt;font-family:

"Arial",sans-serif;background:yellow">Reject

<span

style="font-size:9.0pt;font-family:"Arial",sans-serif">INTERIOR

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Trailer/Container dimensions<span

style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif">: Circle

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Length: Outside of tolerance

of +3/-7" from table below Yes

/ No

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Width: Outside of tolerance

of +/-3" from table below Yes

/ No

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Height: Outside of tolerance

of +/-3" from table below Yes

/ No

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Floor<span

style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif">:

Any nails, foreign objects, contaminants, holes, rot, water damage, nose plate

rusty? Yes / No

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Sides<span

style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif">:

Any holes, cracks, protruding/jagged edges, contaminants, kick (side) plates

rusty? Yes / No

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Roof<span

style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif">:

Any holes, cracks, rib damage, protruding or jagged edges, contaminants? Yes

/ No

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Previous repairs<span

style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif"> (if

present):

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Roof, floor, side panels have

existing repaired areas posing to risk to product? Yes

/ No

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">(Indicate repairs in picture

below and any notes in comments section)

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Export Shipment Container<span

style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif">:

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Eyes/loops at top, middle, or

bottom inside of door are missing or in poor condition,

<span style="font-size:9.0pt;

/ No

line-height:115%;font-family:"Arial",sans-serif">(broken or slack)? Yes

<span

style="font-size:9.0pt;font-family:"Arial",sans-serif">EXTERIOR

Any

damage to: Circle

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Framework, sides, doors,

latches, seals, nuts/bolts/rivets? Yes

/ No

<span style="font-size:9.0pt;

line-height:115%;font-family:"Arial",sans-serif">Any penetrations, cracks,

holes present? Yes

/ No

<table class="MsoNormal" Table border=1 cellspacing=0 cellpadding=0 width=692

style="width:519.0pt;border-collapse:collapse;border:none">

<td width=692 valign=bottom style="width:519.0pt;border:double windowtext 1.5pt;

padding:.75pt .75pt 0in .75pt;height:11.7pt">

<span

style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:black">IF YES

TO ANY OF THE ABOVE INSIDE AND OUTSIDE CHECKS – EITHER FIX AND/OR CORRECT

ISSUE OR <span style="font-size:10.0pt;font-family:"Calibri",sans-serif;

color:black">REJECT TRAILER/CONTAINER<span

style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:black">.... <span

style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:black">NOTE

ACTIONS TAKEN IN THE COMMENTS SECTION AND MARK TRAILER DIAGRAM BELOW TO

IDENTIFY AREA OF CONCERN

</td>

</tr>

</table>

</div>

<img width=594

height=107 id="Picture 1"

src="QUAL%20EWI%2001A%20Trailer%20or%20Container%20Inspection%20Form_files/image001.jpg">

<span style="font-size:10.0pt;font-family:"Arial",sans-serif;

color:black;layout-grid-mode:line">Comments

<table class="MsoNormal" Table border=1 cellspacing=0 cellpadding=0

style="border-collapse:collapse;border:none">

<td width=667 valign=top style="width:6.95in;border:solid windowtext 2.25pt;

padding:0in 5.4pt 0in 5.4pt;height:14.85pt">

<span

style="font-family:"Arial",sans-serif">THIS TRAILER/CONTAINER IS: (circle)

Accepted Rejected

</td>

</tr>

</table>

</div>

<span style="font-size:11.0pt;font-family:"Arial",sans-serif;

color:black;layout-grid-mode:line">______________________________________________________________________________________________________________________________________________________________________

<span style="font-size:8.0pt;font-family:"Arial",sans-serif;

color:gray">

<img width=383

height=83

src="QUAL%20EWI%2001A%20Trailer%20or%20Container%20Inspection%20Form_files/image002.jpg">

<span

style="font-size:11.0pt;font-family:"Arial",sans-serif;color:red">Note: Refrigerated

trucks are not our normal mode of transporation. If used:

<span

style="font-size:11.0pt;font-family:"Arial",sans-serif;color:red">Manager/Supervisor

approval required:_________________________________

<span

style="font-size:11.0pt;font-family:"Arial",sans-serif;color:red">Product must

be protected (cardboard on the floor of the trailer) and only tolerable for

transfers.

</div>

</body>

</html>')

Tom_Slosse · ‎11-29-2019

Hey @Anonymous

Your concat function only has one parameter, while concat expects at least 2 parameters.

You could just use the Create HTML table action to do this or just a compose action.

You're not actually concatenating anything so that's why the Flow fails.

You could just put concat(<html>...</html>, ' ') behind your first parameter and I guess your Flow would run successfully.

Hope this helps

Kind regards

Tom

If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Anonymous · ‎12-02-2019

Hello Tom,

I've tried that as well and still, it fails. That's the reason I was not sure what I was missing?

Tom_Slosse · ‎12-02-2019

Hey @Anonymous

You could try to put all your html in an append to string variable and then put your string into your other action.

Or try and use the HTML table action.

Kind regards

Tom

If this reply has answered your question or solved your issue, please mark this question as answered.

Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Anonymous · ‎12-03-2019

I tried both ways but it still didn't work 😥
However, when I divide the html I've into multiple different concat() function it runs the flow pretty good, but it only manages to show half of the html page I originally have.

Unable to generate a pdf from Flow

Helpful resources

Power Platform Connections Ep 14 | J. Panchal | Thursday, 18 May 2023

May 2023 Community Newsletter and Upcoming Events

Announcing | Super Users - 2023 Season 1

Check out the new Power Platform Communities Front Door Experience!

Microsoft Power Platform Conference | Registration Open | Oct. 3-5 2023