{"id":1890,"date":"2022-07-12T06:02:57","date_gmt":"2022-07-12T06:02:57","guid":{"rendered":"https:\/\/poiseddevelopers.com\/reality-tech\/?p=1890"},"modified":"2024-04-26T12:11:32","modified_gmt":"2024-04-26T12:11:32","slug":"generate-a-pdf-from-microsoft-automate-method-1","status":"publish","type":"post","link":"https:\/\/poiseddevelopers.com\/reality-tech\/generate-a-pdf-from-microsoft-automate-method-1\/","title":{"rendered":"Generate a PDF from Microsoft Automate Method \u2013 1"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/generate-a-pdf-from-microsoft-automate-method-1\/#Generate_a_PDF_of_SharePoint_List_Data_Through_HTML_Template_from_Microsoft_Flow\" title=\"Generate a PDF of SharePoint List Data Through HTML Template from Microsoft Flow\">Generate a PDF of SharePoint List Data Through HTML Template from Microsoft Flow<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/generate-a-pdf-from-microsoft-automate-method-1\/#Generate_a_PDF_of_SharePoint_List_Data_with_Word_Template_from_Microsoft_Flow\" title=\"Generate a PDF of SharePoint List Data with Word Template from Microsoft Flow\">Generate a PDF of SharePoint List Data with Word Template from Microsoft Flow<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/generate-a-pdf-from-microsoft-automate-method-1\/#Part-1\" title=\"Part-1\">Part-1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/generate-a-pdf-from-microsoft-automate-method-1\/#Step-1\" title=\"Step-1\">Step-1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/generate-a-pdf-from-microsoft-automate-method-1\/#Step-2\" title=\"Step-2\">Step-2<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/generate-a-pdf-from-microsoft-automate-method-1\/#Step-3\" title=\"Step-3\">Step-3<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h4 class=\"elementor-heading-title elementor-size-medium\" role=\"heading\" data-uw-rm-heading=\"level\" aria-level=\"3\">Summary<\/h4>\n<p>Recently while working for one of the client\u2019s requirements, in which they wanted to generate a PDF saved in SharePoint Document Library once the user submits a Form. The PDF had to be in a pre-defined format that they were using as Word Document.<\/p>\n<p>This was achieved with 2 different approaches \u2013<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Generate_a_PDF_of_SharePoint_List_Data_Through_HTML_Template_from_Microsoft_Flow\"><\/span><strong>Generate a PDF of SharePoint List Data Through HTML Template from Microsoft Flow<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this approach we created a html of the document and upload as a Template, used the template in Flow to create html file in OneDrive and then converted the file to PDF and saving it in SharePoint Document Library.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Generate_a_PDF_of_SharePoint_List_Data_with_Word_Template_from_Microsoft_Flow\"><\/span><strong>Generate a PDF of SharePoint List Data with Word Template from Microsoft Flow<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this approach we used the predefined format as Template in\u00a0SharePoint\u00a0Document Library, then\u00a0updated\u00a0the file properties and created\u00a0a template in OneDrive\u00a0then\u00a0converting that template to PDF and saving in SharePoint\u00a0Library.<\/p>\n<h3 class=\"elementor-heading-title elementor-size-medium\"><span class=\"ez-toc-section\" id=\"Part-1\"><\/span>Part-1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b><span class=\"TextRun SCXW94198694 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"none\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW94198694 BCX0\" data-ccp-parastyle=\"heading 2\">Generate a PDF of SharePoint List Data Through HTML Template from Microsoft Flow<\/span><\/span>.<\/b><\/p>\n<h3 class=\"elementor-heading-title elementor-size-medium\"><span class=\"ez-toc-section\" id=\"Step-1\"><\/span>Step-1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span class=\"TextRun SCXW246649689 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW246649689 BCX0\">Create a SharePoint\u00a0<\/span><span class=\"NormalTextRun SCXW246649689 BCX0\">Custom\u00a0<\/span><span class=\"NormalTextRun SCXW246649689 BCX0\">List\u00a0<\/span><span class=\"NormalTextRun SCXW246649689 BCX0\">named Conversion-to-PDF-from-Flow\u00a0<\/span><span class=\"NormalTextRun SCXW246649689 BCX0\">with necessary\u00a0<\/span><span class=\"NormalTextRun SCXW246649689 BCX0\">fields<\/span><span class=\"NormalTextRun SCXW246649689 BCX0\">\u00a0to enter the data, required to move to predefined PDF Format.<\/span><span class=\"NormalTextRun SCXW246649689 BCX0\">\u00a0Here I have taken following fields\u00a0<\/span><\/span><span class=\"EOP SCXW246649689 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:-142,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1904 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture1-1-1.webp\" alt=\"img-01\" width=\"535\" height=\"324\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture1-1-1.webp 535w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture1-1-1-300x182.webp 300w\" sizes=\"auto, (max-width: 535px) 100vw, 535px\" \/><\/p>\n<p><span class=\"TextRun SCXW230784568 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW230784568 BCX0\">Create another SharePoint\u00a0<\/span><span class=\"NormalTextRun SCXW230784568 BCX0\">Document\u00a0<\/span><span class=\"NormalTextRun SCXW230784568 BCX0\">Library<\/span>\u00a0<span class=\"NormalTextRun SCXW230784568 BCX0\">with\u00a0<\/span><span class=\"NormalTextRun SCXW230784568 BCX0\">name Test-PDF-Documents<\/span><span class=\"NormalTextRun SCXW230784568 BCX0\">\u00a0to store the generated PDF\u2019<\/span><span class=\"NormalTextRun SCXW230784568 BCX0\">s<\/span><span class=\"NormalTextRun SCXW230784568 BCX0\">.<\/span><\/span><span class=\"EOP SCXW230784568 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:-142,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span class=\"TextRun SCXW232645676 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW232645676 BCX0\">Please note, while creating multi-line columns, make sure the plain text is selected.<\/span><\/span><span class=\"EOP SCXW232645676 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:-142,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h3 class=\"elementor-heading-title elementor-size-medium\"><span class=\"ez-toc-section\" id=\"Step-2\"><\/span>Step-2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span class=\"NormalTextRun SCXW215048848 BCX0\">The\u00a0<\/span><span class=\"NormalTextRun SCXW215048848 BCX0\">HTML<\/span><span class=\"NormalTextRun SCXW215048848 BCX0\">\u00a0Template<\/span><\/p>\n<p><span class=\"TextRun SCXW29265703 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW29265703 BCX0\">Create a html format of the data you want<\/span><span class=\"NormalTextRun SCXW29265703 BCX0\">, here is the format I used, the structure used here contains {tokens} that would be used in Flow compose actions to perform text replacements.\u00a0<\/span><\/span><span class=\"EOP SCXW29265703 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559685&quot;:-142,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1906 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture2-1-1.webp\" alt=\"img-02\" width=\"600\" height=\"314\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture2-1-1.webp 600w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture2-1-1-300x157.webp 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p><span class=\"TextRun SCXW6069999 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW6069999 BCX0\">This is a simple document, for creating more styled document, you can add CSS as per the requirements.<\/span><\/span><span class=\"EOP SCXW6069999 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:-142,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span class=\"NormalTextRun SCXW266571229 BCX0\">Create a SharePoint Document Library<\/span><span class=\"NormalTextRun SCXW266571229 BCX0\">\u00a0named Templates<\/span><span class=\"NormalTextRun SCXW266571229 BCX0\">\u00a0to store the template in html format.<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1907 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture3-1-1.webp\" alt=\"img-03\" width=\"794\" height=\"200\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture3-1-1.webp 794w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture3-1-1-300x76.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture3-1-1-768x193.webp 768w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/p>\n<h3 class=\"elementor-heading-title elementor-size-medium\"><span class=\"ez-toc-section\" id=\"Step-3\"><\/span>Step-3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span class=\"TextRun SCXW148629149 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW148629149 BCX0\">Creating the Flow<\/span><\/span><span class=\"EOP SCXW148629149 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:-142,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li><span class=\"TextRun SCXW19634635 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW19634635 BCX0\">Create the flow with the trigger, when an item is created of SharePoint connector. Select the site collection address and List\u2019s name.<\/span><\/span><span class=\"EOP SCXW19634635 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1909 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture4-1-1.webp\" alt=\"img-04\" width=\"738\" height=\"202\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture4-1-1.webp 738w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture4-1-1-300x82.webp 300w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><\/p>\n<ul>\n<li><span class=\"TextRun SCXW78067630 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW78067630 BCX0\">Click on + sign or next step, add Get Item action of SharePoint connector.\u00a0<\/span><span class=\"NormalTextRun SCXW78067630 BCX0\">Select the Site Collection address and List\u2019s name and select ID parameter from Dynamic content window from When an item is created section.<\/span><\/span><span class=\"EOP SCXW78067630 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1911 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture5-1.webp\" alt=\"img-05\" width=\"739\" height=\"246\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture5-1.webp 739w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture5-1-300x100.webp 300w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/p>\n<ul>\n<li><span class=\"TextRun SCXW111150704 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW111150704 BCX0\">Add an action, Current time of Date Time connector.<\/span><span class=\"NormalTextRun SCXW111150704 BCX0\">\u00a0We would use the same in compose action while creating the file name.\u00a0<\/span><\/span><span class=\"EOP SCXW111150704 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1912 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture6-1.webp\" alt=\"img-06\" width=\"739\" height=\"166\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture6-1.webp 739w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture6-1-300x67.webp 300w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/p>\n<ul>\n<li><span class=\"TextRun SCXW102494387 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW102494387 BCX0\">Add an action, Get File content of SharePoint connector.<\/span><span class=\"NormalTextRun SCXW102494387 BCX0\">\u00a0Select the Site collection address and the File Template, in this case I created a Library named Templates, and Template is the name of the template, we would be using\u00a0<\/span><\/span><span class=\"EOP SCXW102494387 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1914 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture7-1.webp\" alt=\"img-07\" width=\"739\" height=\"203\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture7-1.webp 739w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture7-1-300x82.webp 300w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:218,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Add an action Compose from Data Operations connector, in this action we would replace the token of template with the data from the list. The Expression we would use would be, replace.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/li>\n<\/ul>\n<p>The expression would look something like this,<\/p>\n<pre lang=\"php\"> @{replace(body(\u2018Get_file_content_-_HTML_Content\u2019),'{title}\u2019,body(\u2018Get_item\u2019)[\u2018Title\u2019])}\r\n<\/pre>\n<p>The title token, would be replaced by the Title that we would get from Get Items action.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1919 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture8-1.webp\" alt=\"img-08\" width=\"731\" height=\"139\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture8-1.webp 731w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture8-1-300x57.webp 300w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"2\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:218,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Similarly, we would add 2 compose actions to replace Assigned to and Comments section with the following expression respectively.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/li>\n<\/ul>\n<pre lang=\"php\"> \r\n        @{replace(outputs(\u2018Compose_-_Set_Title\u2019),'{assignedto}\u2019,body(\u2018Get_item\u2019)? [\u2018AssignedTo\u2019]?  [\u2018DisplayName\u2019])}  \r\n\r\n        @{replace(outputs(\u2018Compose_-_Set_Assigned_To\u2019),'{comments}\u2019, body(\u2018Get_item\u2019)? [\u2018Comments\u2019])}<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1922 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture9-1.webp\" alt=\"img-09\" width=\"737\" height=\"304\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture9-1.webp 737w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture9-1-300x124.webp 300w\" sizes=\"auto, (max-width: 737px) 100vw, 737px\" \/><\/p>\n<ul>\n<li><span class=\"TextRun SCXW127075380 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW127075380 BCX0\">Add another Compose action to set the file name. We can set the name as we want,\u00a0<\/span><span class=\"NormalTextRun SCXW127075380 BCX0\">here I have taken Name from the SharePoint list and Current time to differentiate the files.<\/span><span class=\"NormalTextRun SCXW127075380 BCX0\">\u00a0<\/span><\/span><span class=\"EOP SCXW127075380 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1923 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture10-1.webp\" alt=\"img-10\" width=\"739\" height=\"133\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture10-1.webp 739w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture10-1-300x54.webp 300w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/p>\n<ul>\n<li><span class=\"TextRun SCXW170716066 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW170716066 BCX0\">Add an action, Create File of OneDrive for business connector. Select the Folder path, set the file name from the output of the File Name and add .html at its end, select the File Content from the output of action Compose- Set Comments<\/span><\/span><span class=\"EOP SCXW170716066 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1926 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture11-1.webp\" alt=\"img-11\" width=\"736\" height=\"215\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture11-1.webp 736w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture11-1-300x88.webp 300w\" sizes=\"auto, (max-width: 736px) 100vw, 736px\" \/><\/p>\n<ul>\n<li><span class=\"TextRun SCXW246452040 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW246452040 BCX0\">Add an action, Convert File<\/span><span class=\"NormalTextRun SCXW246452040 BCX0\">\u00a0of OneDrive connector. Select the ID from the previous action of Create File\u00a0<\/span><\/span><span class=\"EOP SCXW246452040 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1927 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture12-1.webp\" alt=\"img-12\" width=\"740\" height=\"169\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture12-1.webp 740w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture12-1-300x69.webp 300w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><\/p>\n<ul>\n<li><span class=\"TextRun SCXW193713402 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW193713402 BCX0\">Add an action Create File of SharePoint connector. Select the Site collection address, select the Folder path as the Library where you would like to store the file, set the File Name as the output of action Compose- File Name and add .pdf at its end, set the File Content as the File Content from Dynamic Content of previous action Convert File<\/span><\/span><span class=\"EOP SCXW193713402 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1930 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture13.webp\" alt=\"img-13\" width=\"740\" height=\"255\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture13.webp 740w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture13-300x103.webp 300w\" sizes=\"auto, (max-width: 740px) 100vw, 740px\" \/><\/p>\n<ul>\n<li><span class=\"NormalTextRun SCXW266843916 BCX0\">Add an action to Delete the File created in OneDrive folder, Add Delete File of OneDrive for business connector. Select the ID as the ID that was used to create file from previous Create File action<\/span><span class=\"NormalTextRun SCXW266843916 BCX0\">. Save the Flow.\u00a0<\/span><\/li>\n<\/ul>\n<div style=\"background-color: white; box-shadow: 0 0 10px whitesmoke; padding: 20px; width: 800px;\">\n<h4 style=\"color: black;\">Additional Read<\/h4>\n<p><a style=\"color: #1f6799; text-decoration: none;\" target=\"_blank\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/how-to-migrate-file-server-to-sharepoint-online-expert-guide\/\" rel=\"noopener\">How to Migrate File Server to SharePoint Online [Expert Guide]<\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1933 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture14.webp\" alt=\"img-14\" width=\"735\" height=\"130\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture14.webp 735w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture14-300x53.webp 300w\" sizes=\"auto, (max-width: 735px) 100vw, 735px\" \/><\/p>\n<p><span class=\"TextRun SCXW227440925 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW227440925 BCX0\">The fin<\/span><span class=\"NormalTextRun SCXW227440925 BCX0\">al look of flow would be like this,<\/span><\/span><span class=\"EOP SCXW227440925 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:218,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1936 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture15.webp\" alt=\"img-15\" width=\"767\" height=\"1104\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture15.webp 767w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture15-208x300.webp 208w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture15-711x1024.webp 711w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/p>\n<p><span class=\"TextRun SCXW212342395 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW212342395 BCX0\">Let\u2019s enter data in our SharePoint Custom List Conversion to PDF from Flow,\u00a0<\/span><\/span><span class=\"EOP SCXW212342395 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:218,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1937 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture16.webp\" alt=\"img-16\" width=\"803\" height=\"171\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture16.webp 803w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture16-300x64.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture16-768x164.webp 768w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/p>\n<p><span class=\"TextRun SCXW207944955 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW207944955 BCX0\">The document that would be created inside the Library after the Flow runs would come up as,<\/span><\/span><span class=\"EOP SCXW207944955 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:218,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1939 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture17.webp\" alt=\"img-17\" width=\"803\" height=\"200\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture17.webp 803w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture17-300x75.webp 300w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture17-768x191.webp 768w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/p>\n<p><span class=\"TextRun SCXW75608957 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\" data-uw-rm-lang=\"false\"><span class=\"NormalTextRun SCXW75608957 BCX0\">The file<\/span><span class=\"NormalTextRun SCXW75608957 BCX0\">\u00a0content<\/span>\u00a0<span class=\"NormalTextRun SCXW75608957 BCX0\">will come up<\/span><span class=\"NormalTextRun SCXW75608957 BCX0\">\u00a0like this,<\/span><\/span><span class=\"EOP SCXW75608957 BCX0\" data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:218,&quot;335559737&quot;:-94,&quot;335559739&quot;:160,&quot;335559740&quot;:259,&quot;469777462&quot;:[6521],&quot;469777927&quot;:[0],&quot;469777928&quot;:[1]}\">\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1941 size-full\" src=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture18.webp\" alt=\"img-18\" width=\"760\" height=\"655\" srcset=\"https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture18.webp 760w, https:\/\/poiseddevelopers.com\/reality-tech\/wp-content\/uploads\/2024\/03\/Picture18-300x259.webp 300w\" sizes=\"auto, (max-width: 760px) 100vw, 760px\" \/><\/p>\n<div style=\"background-color: white; box-shadow: 0 0 10px whitesmoke; padding: 20px; width: 800px;\">\n<h4 style=\"color: black;\">Are you in need of assistance? We can help!<\/h4>\n<p>Book a live 1-on-1 call with the experts of Reality Tech to find out how we will help you to achieve your goal. You\u2019ll find our solutions robust, scalable, and dependable.<\/p>\n<p><a style=\"color: #1f6799; text-decoration: none;\" target=\"_blank\" href=\"https:\/\/poiseddevelopers.com\/reality-tech\/contact-us\/\" rel=\"noopener\">Let\u2019s talk!<\/a><\/p>\n<\/div>\n<p>Please post your question, if you will find while implementing this process. Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Summary Recently while working for one of the client\u2019s requirements, in which they wanted to generate a PDF saved in SharePoint Document Library once the user submits a Form. The PDF had to be in a pre-defined format that they were using as Word Document. This was achieved with 2 different approaches \u2013 Generate a [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":1892,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[19],"tags":[],"class_list":["post-1890","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate"],"acf":[],"_links":{"self":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/comments?post=1890"}],"version-history":[{"count":3,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1890\/revisions"}],"predecessor-version":[{"id":2925,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/posts\/1890\/revisions\/2925"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media\/1892"}],"wp:attachment":[{"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/media?parent=1890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/categories?post=1890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/poiseddevelopers.com\/reality-tech\/wp-json\/wp\/v2\/tags?post=1890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}