{"id":111028,"date":"2019-12-18T09:00:35","date_gmt":"2019-12-18T17:00:35","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/"},"modified":"2025-06-11T08:00:50","modified_gmt":"2025-06-11T15:00:50","slug":"intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/","title":{"rendered":"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data"},"content":{"rendered":"

Jay from Encodian<\/a> has compiled this guide showing how we can use Power Automate to create a document approval sheet using Power Automate approval data before embedding it within a document.<\/p>\n

This is a common use case which is a regular topic within the community!<\/p>\n

Encodian<\/a> is one of our trusted Power Platform connector partners which contains a whopping 33 different actions covering document format conversion, redaction, watermarking, OCR, PDF to PDF\/A, data extraction, merging, splitting, securing, search and replace, archiving (ZIP files!) and a whole boat load more!<\/p>\n

Flow Overview<\/strong><\/p>\n

Many organisations include the document approval sheet in the document either at the start or end of the document. Using this approach requires the user to manually update the approval table which is difficult to manage especially when using an automated approval process to generate an approved version of the document, i.e. you can\u2019t change the document once it\u2019s approved! And you can\u2019t really complete the approval table (dates, comments) until the approval process is complete.<\/p>\n

This Flow will demonstrate how to dynamically generate the approval sheet from Flow approval data and add it to an approved rendition of the document (PDF).<\/p>\n

Let\u2019s build the Flow!<\/strong><\/p>\n

Navigate to the SharePoint document library which will store and manage the documents that will be sent for approval.<\/p>\n

Click \u2018Flow<\/strong>\u2019, click \u2018Create a Flow<\/strong>\u2019<\/p>\n

\"\"<\/p>\n

Click \u2018Show more<\/strong>\u2019<\/p>\n

\"\"<\/p>\n

Select the \u2018Complete a custom action for the selected file<\/strong>\u2019<\/p>\n

\"\"<\/p>\n

Click \u2018Continue<\/strong>\u2019<\/p>\n

\"\"<\/p>\n

Select the default name of the Flow text and change to \u2018Submit for Approval<\/strong>\u2019<\/p>\n

\"\"<\/p>\n

Add a SharePoint \u2018Get File Content<\/strong>\u2019 action to the Flow<\/p>\n

\"\"
\n\u00a0<\/em><\/p>\n

Configure the \u2018Get File Content<\/strong>\u2019 action as follows:<\/p>\n

Site Address<\/strong>: This must be set as per the \u2018Site Address<\/strong>\u2019 value set in the \u2018Get File Properties<\/strong>\u2019 action<\/p>\n

File Identifier<\/strong>: Select the \u2018Identifier<\/strong>\u2019 property returned by the Get File Properties<\/strong>\u2019 action<\/p>\n

\"\"<\/p>\n

Add a \u2018Start and wait for an approval<\/strong>\u2019 action to the Flow<\/p>\n

\"\"<\/p>\n

Select the required approval type – this demo uses the \u2018Approve\/Reject \u2013 Everyone must approve<\/strong>\u2019 approval type<\/p>\n

\u00a0<\/em>
\n\"\"
\n\u00a0<\/em><\/p>\n

Complete the \u2018Start and wait for an approval<\/strong>\u2019 action configuration as follows:<\/p>\n

Title<\/strong>: Set to \u2018Official Document Approval Request<\/strong>\u2019 or similar<\/p>\n

Assigned To<\/strong>: Enter the users who will be asked to approve the document<\/p>\n

Details<\/strong>: Enter additional detail if needed using markdown<\/p>\n

Item link<\/strong>: Select the \u2018Link to Item<\/strong>\u2019 property returned by the \u2018Get file properties<\/strong>\u2019 action<\/p>\n

\"\"
\nItem link description: <\/strong>Select the \u2018File name with extension<\/strong>\u2019 property returned by the \u2018Get file properties<\/strong>\u2019 action<\/p>\n

\"\"<\/p>\n

At this stage the Flow approval process is now complete. The next stage is to create the official rendition of the document, obtain the approval data and build the approval sheet that we will insert info the approved PDF document.<\/p>\n

Add a \u2018Initialize variable<\/strong>\u2019 action<\/p>\n

Name<\/strong>: Set to \u2018ApprovalSheetHtml<\/strong>\u2019<\/p>\n

Type<\/strong>: Select \u2018String<\/strong>\u2019<\/p>\n

Value<\/strong>: Copy and paste the contents of the \u2018ApprovalsheetHtml-InitialValue.html<\/strong>\u2019 file<\/p>\n

\"\"
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/em>NOTE: <\/strong>This action is required later within the Flow\u2026 more details to follow<\/p>\n

Add a \u2018Condition<\/strong>\u2019 action<\/p>\n

Choose a value:<\/strong> Select the \u2018Outcome<\/strong>\u2019 property returned by the \u2018Start and wait for an approval<\/strong>\u2019 action<\/p>\n

\"\"
\nEquation: <\/strong>Set to \u2018does not contain<\/strong>\u2019<\/p>\n

Choose a value:<\/strong> Enter \u2018Reject<\/strong>\u2019<\/p>\n

\"\"<\/p>\n

\u00a0<\/p>\n

This step is optional; it demonstrates how to change document content using Power Automate. In this example an action is added to update the document footer to specify the correct approval date:<\/em>
\n\"\"<\/p>\n

Inside the \u2018If No\u2019 <\/strong>branch, add some relevant handling to inform the requesting user the approval has been rejected (see example below):<\/p>\n

\"\"<\/p>\n

Inside the \u2018If Yes\u2019 <\/strong>branch;<\/p>\n

Add the \u2018Search and Replace Text<\/strong><\/a>\u2019 Encodian action<\/p>\n

File Type<\/strong>: Select \u2018DOCX<\/strong>\u2019<\/p>\n

Filename<\/strong>: Select the \u2018File name with extension<\/strong>\u2019 property returned by the \u2018Get file properties<\/strong>\u2019 action<\/p>\n

\"\"
\nFile Content<\/strong>: Select the \u2018File Content<\/strong>\u2019 property returned by the \u2018Get file content<\/strong>\u2019 action<\/p>\n

\"\"
\nPhrases Search Test \u2013 1<\/strong>: Enter [APPROVALDATE]<\/strong>
\nPhrases Is Expression \u2013 1<\/strong>: Select \u2018No<\/strong>\u2019<\/p>\n

Phrases Replacement Text \u2013 1<\/strong>: Select the \u2018Completion Date<\/strong>\u2019 property returned by the \u2018Start and wait for an approval<\/strong>\u2019 action<\/p>\n

\u00a0<\/strong>
\n\"\"<\/p>\n

\u00a0<\/p>\n

NOTE: <\/strong>If required you can specify exact font size, colour, etc. otherwise the current format of the word document text will be inherited.<\/p>\n

\u00a0<\/p>\n

Add the \u2018Convert to PDF<\/strong><\/a>\u2019 Encodian action<\/p>\n

Filename<\/strong>: Select the \u2018Filename<\/strong>\u2019 property returned by the \u2018Search and Replace Text<\/strong>\u2019 action<\/p>\n

\"\"
\nFile Content<\/strong>: Select the \u2018File Content<\/strong>\u2019 property returned by the \u2018Search and Replace Text<\/strong>\u2019 action<\/p>\n

\"\"
\nPDF Filename<\/strong>: Select the \u2018Filename<\/strong>\u2019 property returned by the \u2018Search and Replace Text<\/strong>\u2019 action. The Encodian action will automatically ensure that the output filename has a PDF extension<\/u>.<\/p>\n

\"\"<\/p>\n

Click \u2018Show advanced options\u2019<\/strong>
\n\"\"<\/p>\n

\u00a0<\/p>\n

Remove Markup: <\/strong>Select \u2018Yes<\/strong>\u2019, this ensure that any comments \/ tracked changes are removed from the resultant PDF document.<\/p>\n

\u00a0<\/p>\n

\"\"<\/p>\n

The next step is to create the approval sheet. We have several options\/approaches which would work; if the document already contains an \u2018Overview\/Title Page\u2019 we could:<\/p>\n

Use the \u2018Insert HTML to PDF<\/strong><\/a>\u2019 action to insert the approval sheet at a specific location within the PDF document.<\/p>\n

Use the \u2018Insert HTML to PDF<\/strong><\/a>\u2019 action to append the approval sheet to the end of the PDF document.<\/p>\n

Split the source PDF document into two separate documents using the \u2018Split PDF<\/strong><\/a>\u2019 action, create the approval sheet using the \u2018Convert HTML to PDF<\/strong><\/a>\u2019 action and the merge the three files in the correct order using the \u2018Merge Document Array to PDF<\/strong><\/a>\u2019 action<\/p>\n

However, we advise our customers not to include an \u2018Overview\/Title Page\u2019 or \u2018Approval Sheets\u2019 in the actual documents as these can easily be added dynamically when needed, providing enhanced control and options for adding these types of pages in a document. This is what we\u2019ll now do\u2026<\/p>\n

Add an \u2018Append to string variable<\/strong>\u2019 action<\/p>\n

Name<\/strong>: Select the \u2018ApprovalSheetHtml<\/strong>\u2019 variable<\/p>\n

Value<\/strong>: Select the \u2018Responses Approver email<\/strong>\u2019 property returned by the \u2018Start and wait for an approval<\/strong>\u2019 action<\/p>\n

\"\"
\nNOTE:<\/strong> This should automatically place the \u2018Append to string variable<\/strong>\u2019 action in a \u2018Apply to each<\/strong>\u2019 loop.<\/p>\n

Value<\/strong>: Enter the following text<\/p>\n

<tr><\/p>\n

<td class=”TdData utilW100″>@{items(‘Apply_to_each’)?[‘responder’]?[‘displayName’]}<\/td><\/p>\n

<td class=”TdData”>@{items(‘Apply_to_each’)?[‘responseDate’]}<\/td><\/p>\n

<td class=”TdData”>@{items(‘Apply_to_each’)?[‘comments’]}<\/td><\/p>\n

<\/tr><\/p>\n

\"\"
\n\u00a0<\/em><\/p>\n

Underneath the \u2018Apply to each<\/strong>\u2019 loop, add an \u2018Append to string variable<\/strong>\u2019 action<\/p>\n

Name<\/strong>: Select the \u2018ApprovalSheetHtml<\/strong>\u2019 variable<\/p>\n

Value<\/strong>: Enter the following text<\/p>\n

<\/table><\/div><\/div><\/body><\/html><\/p>\n

\"\"<\/p>\n

Add a \u2018Insert HTML to PDF\u2019<\/strong> action<\/p>\n

NOTE: <\/strong>This screen shots of the \u2018Insert HTML to PDF\u2019<\/strong> action show some configuration options (Page Number, Page Size, Page Orientation) which are currently under deployment and may not reach your region for another 2 to 3 weeks.<\/em>
\nFilename<\/strong>: Select the \u2018Filename<\/strong>\u2019 property returned by the \u2018Convert to PDF<\/strong>\u2019 action<\/p>\n

\"\"
\nFile Content<\/strong>: Select the \u2018File Content<\/strong>\u2019 property returned by the \u2018Convert to PDF<\/strong>\u2019 action<\/p>\n

\"\"
\nHTML Data<\/strong>: Select the \u2018ApprovalSheetHtml<\/strong>\u2019 variable<\/p>\n

\"\"
\nHTML Insert Location: <\/strong>Select \u2018Prepend\u2019<\/strong><\/p>\n

\u00a0<\/p>\n

\"\"
\n\u00a0<\/em>
\nNOTE: <\/strong>If you cannot see the <\/em>\u2018HTML Insert Location\u2019<\/strong> your region has not yet received the pending updates, simply click \u2018Show advanced options\u2019<\/strong> to update the \u2018HTML Insert Location\u2019<\/strong> option<\/p>\n

The approval sheet containing document information and approval details has now been added to the document. You may now wish to dynamically add a document title sheet.<\/p>\n

Optional Document Title Sheet Insertion Example<\/strong><\/p>\n

This is already a lengthy post, so we\u2019ve just included a basic example for dynamically creating a document title sheet as a taster!<\/p>\n

A Word template is retrieved from SharePoint, the Encodian \u2018Search and Replace\u2019 action used to replace placeholder text with the document title and approval date, a PDF rendition is created and then merged with the actual PDF document which already contains the approval sheet.<\/p>\n

\"\"<\/p>\n

The resulting title sheet document:<\/p>\n

\"\"
\nFinal Flow Action<\/strong><\/p>\n

Add the resulting approved document to the required location. In this example we\u2019ll simply add the file back to the originating location.<\/p>\n

Add a \u2018Create File<\/strong>\u2019 SharePoint action<\/p>\n

Site Address<\/strong>: This must be set as per the \u2018Site Address<\/strong>\u2019 value set in the \u2018Get File Properties<\/strong>\u2019 action<\/p>\n

Folder Path<\/strong>: Select the \u2018Folder Path\u2019<\/strong> property returned by the \u2018Get file properties<\/strong>\u2019 action<\/p>\n

\"\"
\nFilename<\/strong>: Select the \u2018Filename<\/strong>\u2019 property returned by the \u2018Insert HTML to PDF<\/strong>\u2019 action<\/p>\n

\"\"
\nFile Content<\/strong>: Select the \u2018File Content<\/strong>\u2019 property returned by the \u2018Insert HTML to PDF<\/strong>\u2019 action<\/p>\n

\"\"
\nLet\u2019s Test!<\/strong><\/p>\n

Before you test, we advise reviewing the following blog post which outlines how to share your Flow with users correctly to ensure connections are shared with the correct configuration to negate the need for users having to enter unnecessary connector authentication information such as API Keys:<\/p>\n

Reference Guide: <\/strong>Prevent users needing to enter an API Key in Power Automate<\/a><\/p>\n

The \u2018run only users<\/strong>\u2019 configuration for this demonstration flow has been set to the following configuration:<\/p>\n

\"\"<\/p>\n

Go to SharePoint and start the Flow<\/p>\n

\"\"<\/p>\n

Click \u2018Continue<\/strong>\u2019<\/p>\n

\"\"<\/p>\n

The approved PDF file with embedded approval sheet should have been created<\/p>\n

\"\"
\nClosing thoughts\u2026<\/strong><\/p>\n

Although this post has focused on the creation and manipulation of a PDF document, this could also be achieved with a Word document (docx) using the \u2018HTML to Word<\/a>\u2019 and \u2018Merge Word Documents<\/a>\u2019 actions to replace their PDF equivalents.<\/p>\n","protected":false},"excerpt":{"rendered":"

Jay from Encodian has compiled this guide showing how we can use Power Automate to create a document approval sheet using Power Automate approval data before embedding it within a document.<\/p>\n","protected":false},"author":348,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[3423],"job-role":[],"product":[3474],"property":[],"topic":[],"coauthors":[2899],"class_list":["post-111028","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-tips-and-guides","product-power-automate"],"yoast_head":"\nIntermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Jay from Encodian has compiled this guide showing how we can use Power Automate to create a document approval sheet using Power Automate approval data before embedding it within a document.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-18T17:00:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:00:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"839\" \/>\n\t<meta property=\"og:image:height\" content=\"190\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jonathon Levesque\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathon Levesque\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jonathon-levesque\/\",\"@type\":\"Person\",\"@name\":\"Jonathon Levesque\"}],\"headline\":\"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data\",\"datePublished\":\"2019-12-18T17:00:35+00:00\",\"dateModified\":\"2025-06-11T15:00:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/\"},\"wordCount\":1513,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png\",\"keywords\":[\"Flow of the Week\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/\",\"name\":\"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png\",\"datePublished\":\"2019-12-18T17:00:35+00:00\",\"dateModified\":\"2025-06-11T15:00:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#primaryimage\",\"url\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png\",\"contentUrl\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/017e233f3881f5857f3e7f6f221ef772\",\"name\":\"Jonathon Levesque\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g42ef9de3d3e22347884fca1cf41497c5\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g\",\"caption\":\"Jonathon Levesque\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jolevesq\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/","og_locale":"en_US","og_type":"article","og_title":"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data - Microsoft Power Platform Blog","og_description":"Jay from Encodian has compiled this guide showing how we can use Power Automate to create a document approval sheet using Power Automate approval data before embedding it within a document.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2019-12-18T17:00:35+00:00","article_modified_time":"2025-06-11T15:00:50+00:00","og_image":[{"width":839,"height":190,"url":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png","type":"image\/png"}],"author":"Jonathon Levesque","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathon Levesque","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jonathon-levesque\/","@type":"Person","@name":"Jonathon Levesque"}],"headline":"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data","datePublished":"2019-12-18T17:00:35+00:00","dateModified":"2025-06-11T15:00:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/"},"wordCount":1513,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#primaryimage"},"thumbnailUrl":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png","keywords":["Flow of the Week"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/","name":"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#primaryimage"},"thumbnailUrl":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png","datePublished":"2019-12-18T17:00:35+00:00","dateModified":"2025-06-11T15:00:50+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#primaryimage","url":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png","contentUrl":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2019\/12\/1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2019\/12\/18\/intermediate-flow-of-the-week-create-and-insert-a-document-approval-sheet-using-flow-approval-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Intermediate | Flow of The Week: Create and insert a document approval sheet using Flow approval data"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/017e233f3881f5857f3e7f6f221ef772","name":"Jonathon Levesque","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g42ef9de3d3e22347884fca1cf41497c5","url":"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g","caption":"Jonathon Levesque"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jolevesq\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/111028","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/348"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=111028"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/111028\/revisions"}],"predecessor-version":[{"id":130714,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/111028\/revisions\/130714"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=111028"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=111028"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=111028"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=111028"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=111028"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=111028"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=111028"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=111028"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}