{"id":1456,"date":"2021-09-17T19:06:42","date_gmt":"2021-09-17T19:06:42","guid":{"rendered":"https:\/\/365stack.in\/?p=1456"},"modified":"2023-06-25T09:54:03","modified_gmt":"2023-06-25T09:54:03","slug":"powerapps-print-form-to-pdf","status":"publish","type":"post","link":"https:\/\/365stack.in\/index.php\/2021\/09\/17\/powerapps-print-form-to-pdf\/","title":{"rendered":"How to Print Scrollable Screen to PDF in PowerApps"},"content":{"rendered":"\n

One of the common requirements in any application is to print the data either to save the form as PDF or print the form. PowerApps provides Print() function<\/a> to print the screen in a printable format, but the limitation is the screen height cannot be greater than 2164px. <\/p>\n\n\n\n

If a Scrollable screen is used for displaying a very large form or gallery is used to show dynamic data where the screen height cannot be predicted, in such cases we have to rely on HTML form, with the help of Power Automate a pdf can be generated which can be used for printing.<\/p>\n\n\n\n

One of the limitations is some of the HTML tags and CSS styles will not work in the “Convert file” action in Onedrive. For Eg: CSS “Display” property will not work properly.<\/p>\n\n\n\n

On Print Button Click:<\/p>\n\n\n\n

UpdateContext({locHtml:\"<html><!--Your HTML--><\/html>\"});\nUpdateContext({locHtmlurl:PrinfForm.Run(locHtml)});\nLaunch(locHtmlurl.pdfurl)<\/code><\/pre>\n\n\n\n
In the HTML to add the form data we have to use string concatenation like below:<\/p>\n\n\n
\n
\"Dynamic
Dynamic Data<\/figcaption><\/figure>\n<\/div>\n\n\n
To Display the gallery or Datatable data we have to use the Concat function:<\/p>\n\n\n
\n
\"\"
To Display Gallery data<\/figcaption><\/figure>\n<\/div>\n\n\n
To Display gallery data<\/p>\n\n\n\n
Concat(gal.AllItems,\"<tr><td>\"&galLabel1.Text&\"<\/td><td>\"&galLabel1.Text&\"<\/td><\/td>\")<\/code><\/pre>\n\n\n\n
All we are doing is recreating the form structure in HTML and passing the HTML to PowerAutomate, In PowerAutomate using One Drive connector an HTML file is created and it is converted to PDF as simple as that.<\/p>\n\n\n\n