cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AppsCreator
Level: Powered On

Unable to generate a pdf from Flow

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?

flow_error.png

Can someone help me in this regards?

9 REPLIES 9
Super User
Super User

Re: Unable to generate a pdf from Flow

looks like you have a expression error.

 

can you share the configuration of your action

Community Support Team
Community Support Team

Re: Unable to generate a pdf from Flow

Hi @AppsCreator,

 

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.

Highlighted
charlon_cabrera
Level: Powered On

Re: Unable to generate a pdf from Flow

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

image.png

 

 

 

Super User
Super User

Re: Unable to generate a pdf from Flow

Hey @AppsCreator 

 

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





AppsCreator
Level: Powered On

Re: Unable to generate a pdf from Flow

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>

<meta http-equiv=Content-Type content="text/html; charset=windows-1252">

<meta name=Generator content="Microsoft Word 15 (filtered)">

<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>

 

<body lang=EN-US>

 

<div class=WordSection1>

 

<p class="MsoNormal" text-align=center style="text-align:center"><b><span

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

 

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

text-indent:35.4pt"><b><span style="font-size:11.0pt">&nbsp;</span></b></p>

 

<p class="MsoNormal" text-align=center style="text-align:center"><b><span

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

 

<p class="MsoNormal"><b><span style="font-size:4.0pt;font-family:"Arial",sans-serif">&nbsp;</span></b></p>

 

<div style="border:double windowtext 1.5pt;padding:1.0pt 4.0pt 0in 4.0pt">

 

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

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

SHIPMENTS</span></b></p>

 

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

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

color:red">DO NOT LOAD OE SHIPMENTS ONTO REFRIGERATED TRAILERS</span></u></b></p>

 

<p class="MsoNormal" style="border:none;padding:0in"><b><span style="font-size:

9.0pt;font-family:"Arial",sans-serif">&nbsp;</span></b></p>

 

<p class="MsoNormal" style="border:none;padding:0in"><b><u><span

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

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

manufacture (no older than 9 years 10 months) ________</span></b></p>

 

<p class="MsoNormal" style="border:none;padding:0in"><b><span style="font-size:

9.0pt;font-family:"Arial",sans-serif">&nbsp;</span></b></p>

 

<p class="MsoNormal" style="border:none;padding:0in"><b><u><span

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

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

(if capable)?                                    Yes / No / NA</span></b></p>

 

</div>

 

<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Arial",sans-serif">                                                                        </span></b></p>

 

<div style="border:double windowtext 1.5pt;padding:1.0pt 4.0pt 1.0pt 4.0pt">

</div>

<p class="MsoNormal"><b><u><span style="font-size:10.0pt;font-family:"Arial",sans-serif;

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

font-family:"Arial",sans-serif;background:yellow">: </span></b></p>

 

<p class="MsoNormal" align=center style="text-align:center"><b><span

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

numerical identification clear and readable?                                                           Yes

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

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

"Arial",sans-serif;background:yellow">Reject</span></b></p>

 

<p class="MsoNormal" align=center style="text-align:center"><b><u><span

style="font-size:9.0pt;font-family:"Arial",sans-serif">INTERIOR</span></u></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><u><span style="font-size:9.0pt;

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

style="font-size:9.0pt;line-height:115%;font-family:"Arial",sans-serif">:                                                                                                                               <u>Circle</u></span></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><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></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><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></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><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></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><u><span style="font-size:9.0pt;

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

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

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

rusty?                             Yes / No</span></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><u><span style="font-size:9.0pt;

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

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

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

rusty?                               Yes / No</span></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><u><span style="font-size:9.0pt;

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

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

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

/ No</span></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><u><span style="font-size:9.0pt;

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

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

present):</span></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><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></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><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></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><u><span style="font-size:9.0pt;

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

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

 

<p class="MsoNormal" style="line-height:115%"><b><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></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;

/ No</span></b></p>

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

 

<p class="MsoNormal" align=center style="text-align:center"><b><u><span

style="font-size:9.0pt;font-family:"Arial",sans-serif">EXTERIOR</span></u></b></p>

 

<p class="MsoNormal"><b><u><span style="font-size:9.0pt;font-family:"Arial",sans-serif">Any

damage to</span></u></b><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif">:                                                                                                                                                        <u>Circle</u></span></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><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></b></p>

 

<p class="MsoNormal" style="line-height:115%"><b><span style="font-size:9.0pt;

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

holes present?                                                                                                           Yes

/ No</span></b></p>






<div align=center>

 

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

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

<tr style="height:11.7pt">

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

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

<p class="MsoNormal" align=center style="text-align:center"><b><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></b><b><u><span style="font-size:10.0pt;font-family:"Calibri",sans-serif;

color:black">REJECT TRAILER/CONTAINER</span></u></b><b><span

style="font-size:9.0pt;font-family:"Calibri",sans-serif;color:black">.... </span></b><b><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</span></b></p>

</td>

</tr>

</table>

 

</div>

 

<p class="MsoNormal" align=center style="text-align:center"><img width=594

height=107 id="Picture 1"

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

 

<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif;

color:black;layout-grid-mode:line">Comments</span></b></p>






<div align=center>

 

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

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

<tr style="height:14.85pt">

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

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

<p class="MsoNormal" align=center style="text-align:center"><b><span

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

Accepted                    Rejected</span></b></p>

</td>

</tr>

</table>

 

</div>

 

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

color:black;layout-grid-mode:line">______________________________________________________________________________________________________________________________________________________________________</span></p>

 

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

color:gray">&nbsp;</span></p>

 

<p class="MsoNormal" align=center style="text-align:center"><img width=383

height=83

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

 

<p class="MsoNormal" align=center style="text-align:center"><b><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></b></p>

 

<p class="MsoNormal" align=center style="text-align:center"><b><span

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

approval required:_________________________________</span></b></p>

 

<p class="MsoNormal" align=center style="text-align:center"><b><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.</span></b></p>

</div>

</body>

</html>')

Super User
Super User

Re: Unable to generate a pdf from Flow

Hey @AppsCreator 

 

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





AppsCreator
Level: Powered On

Re: Unable to generate a pdf from Flow

Hello Tom,

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

Super User
Super User

Re: Unable to generate a pdf from Flow

Hey @AppsCreator 

 

 

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





Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!





AppsCreator
Level: Powered On

Re: Unable to generate a pdf from Flow

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.

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,983)