Mass printing of tickets

HelpDesk
1

Hi folks,

we would like to print/save all of our ~15,000 tickets as PDFs in order to fill a document library with these PDFs and have a SharePoint agent search through them to support our agents. Currently, I only see the very manual printing option, where each individual ticket has to be opened and the “Print” button clicked. Does anyone have a streamlined solution to manage this automatically?

2

Hi!

You can create a Power Automate flow to retrieve comments, save them as HTML files, and convert to PDF.

  1. Start the flow manually and use the HelpDesk connector to retrieve all tickets. You may need to specify the top count to get them all.

image
image643×433 28.1 KB

  1. Initialise a string variable.

image
image623×199 7.32 KB

  1. For each ticket, get all comments using the HelpDesk connector.

image
image691×307 12.3 KB

  1. Append each comment to the string variable using HTML markup to have the desired layout.

image
image712×736 29.4 KB

  1. Save the comments for the current ticket in OneDrive and convert the HTML files to PDF.

image
image676×705 26.6 KB

  1. Save the converted file to the required SharePoint library and clear the string variable.

image
image675×605 23.5 KB

  1. Here is the flow overview.

image
image742×1005 35.3 KB

Will it work for you?