{"id":15145,"date":"2026-07-18T01:57:45","date_gmt":"2026-07-18T01:57:45","guid":{"rendered":"https:\/\/powergi.net\/?p=15145"},"modified":"2026-07-30T15:11:40","modified_gmt":"2026-07-30T15:11:40","slug":"office-scripts-in-power-automate-environments","status":"publish","type":"post","link":"https:\/\/powergi.net\/de\/blog\/office-scripts-in-power-automate-environments\/","title":{"rendered":"Wie man Office Scripts in Power Automate \u00fcber Umgebungen hinweg ausf\u00fchrt"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"15145\" class=\"elementor elementor-15145\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6c05f6b e-flex e-con-boxed e-con e-parent\" data-id=\"6c05f6b\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d46225e elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"d46225e\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"exclude_headings_by_selector\":[],\"no_headings_message\":\"No headings were found on this page.\",\"headings_by_tags\":[\"h2\",\"h3\",\"h4\",\"h5\",\"h6\"],\"marker_view\":\"numbers\",\"minimize_box\":\"yes\",\"minimized_on\":\"tablet\",\"hierarchical_view\":\"yes\",\"min_height\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_tablet\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]},\"min_height_mobile\":{\"unit\":\"px\",\"size\":\"\",\"sizes\":[]}}' data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__d46225e\" aria-expanded=\"true\" aria-label=\"Open table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__d46225e\" aria-expanded=\"true\" aria-label=\"Close table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__d46225e\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f173978 elementor-widget elementor-widget-heading\" data-id=\"f173978\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">What are environment-aware Office Scripts in Power Automate?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-867e460 elementor-widget elementor-widget-text-editor\" data-id=\"867e460\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>When <a href=\"https:\/\/powergi.net\/blog\/create-a-power-automate-flow\/\">building a Power Automate flow<\/a> that runs an Office Script, the Power Automation prompts for the SharePoint site, the document library, the list name, and the script and workbook IDs, which by default lets makers select from a dropdown of folder selection:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f351b8 elementor-widget elementor-widget-image\" data-id=\"2f351b8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"981\" height=\"541\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image001.png\" class=\"attachment-large size-large wp-image-15146\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image001.png 981w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image001-600x331.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image001-768x424.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image001-18x10.png 18w\" sizes=\"(max-width: 981px) 100vw, 981px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b4a9238 elementor-widget elementor-widget-text-editor\" data-id=\"b4a9238\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Above works well until we deploy the solution in QA or Prod and we need to make updates to the office script without affecting any of the environments.<\/p><p>An \u201cenvironment-aware\u201d Office Script setup means the Power Automat workflow uses environment variables or configuration tables with values that are different in each of the environments, to so that each environment will point to different SharePoint sites, libraries, and Office Scripts. Envrionment separation for office script is really important because it lets us keep a clean separation between development, QA and production.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e846cca elementor-widget elementor-widget-heading\" data-id=\"e846cca\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How to Run Office Scripts in Power Automate Across Environments<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1ed706 elementor-widget elementor-widget-text-editor\" data-id=\"a1ed706\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>This blog will show the step-by-step process for setting up a Power Automate workflow that runs an office script that is connected to separate SharePoint sites. You can also watch a walkthrough in our YouTube channel<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ccc933 elementor-widget elementor-widget-video\" data-id=\"5ccc933\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings='{\"youtube_url\":\"https:\\\/\\\/youtu.be\\\/iX_pEcxRtF8?si=9hGVvRJIPLIrdMf1\",\"video_type\":\"youtube\",\"controls\":\"yes\"}' data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9c62cab elementor-widget elementor-widget-text-editor\" data-id=\"9c62cab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The example used for the video and for this blog is a simple Excel template automation:<\/p><ul><li>Trigger: whenever a new project is added to a SharePoint \u201cprojects\u201d list,<\/li><li>Actions: get the contents of a template file, create a copy of the template, and finally run an Office Script that fills in the copy using four input parameters (project name, company, department, and investment).<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-20d36eb elementor-widget elementor-widget-image\" data-id=\"20d36eb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"936\" height=\"376\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image006.png\" class=\"attachment-large size-large wp-image-15147\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image006.png 936w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image006-600x241.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image006-768x309.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image006-18x7.png 18w\" sizes=\"(max-width: 936px) 100vw, 936px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2359e92 elementor-widget elementor-widget-heading\" data-id=\"2359e92\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Pre-requisite: Make sure your workflow is part of a solution<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6a6ac0f elementor-widget elementor-widget-text-editor\" data-id=\"6a6ac0f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Make sure the flow already lives inside a solution, for the example in the video and this blog, the solution name we are using is \u201cProject Template Automation\u201d.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ee2924 elementor-widget elementor-widget-image\" data-id=\"2ee2924\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1200\" height=\"252\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image007-2048x430.png\" class=\"attachment-large size-large wp-image-15148\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image007-2048x430.png 2048w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image007-600x126.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image007-768x161.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image007-1536x323.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image007-18x4.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1e93729 elementor-widget elementor-widget-heading\" data-id=\"1e93729\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 1: Create SharePoint library and lists with matching structures<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e9c0aa9 elementor-widget elementor-widget-text-editor\" data-id=\"e9c0aa9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>It is recommended that the SharePoint sites for each environment have identical structures:<\/p><div id=\"seology-cta-1\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7267\" class=\"elementor elementor-7267\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Turn your ideas into digital solutions<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Our team guides you step by step to build custom apps in Power Platform.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/de\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div><ul><li>Same document library name (e.g., \u201cTemplates\u201d),<\/li><li>Same subfolder for generated files (e.g., \u201cFiles\u201d),<\/li><li>Same template file and Office Script uploaded to both sites.<\/li><li>Same SharePoint list for the trigger<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2837982 elementor-widget elementor-widget-heading\" data-id=\"2837982\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 2: Create an environment variable for the SharePoint site<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8589c7 elementor-widget elementor-widget-text-editor\" data-id=\"a8589c7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Open the solution, and go to <strong>New &gt; More &gt; Environment Variable<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c8304f elementor-widget elementor-widget-image\" data-id=\"7c8304f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"785\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image009.png\" class=\"attachment-large size-large wp-image-15149\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image009.png 1632w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image009-600x393.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image009-768x503.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image009-1536x1005.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image009-18x12.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-426331c elementor-widget elementor-widget-text-editor\" data-id=\"426331c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Set the data type to <strong>Data source<\/strong>, then choose <strong>SharePoint<\/strong>, and select <strong>Site<\/strong>. Paste the URL of the development SharePoint site as the value or select from the dropdown:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f222d5c elementor-widget elementor-widget-image\" data-id=\"f222d5c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"773\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image011-2048x1319.png\" class=\"attachment-large size-large wp-image-15150\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image011-2048x1319.png 2048w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image011-600x387.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image011-768x495.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image011-1536x989.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image011-18x12.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-05359be e-flex e-con-boxed e-con e-parent\" data-id=\"05359be\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1079afe elementor-widget elementor-widget-heading\" data-id=\"1079afe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 3: Create an environment variable for the SharePoint list<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0f7dab elementor-widget elementor-widget-text-editor\" data-id=\"b0f7dab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Now let\u2019s the same but for the SharePoint list. This time we will pick <strong>SharePoint &gt; List<\/strong>. This is the variable that will be used in the trigger, the SharePoint list that will have the project data<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c7aacc elementor-widget elementor-widget-image\" data-id=\"8c7aacc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"770\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image013-2048x1314.png\" class=\"attachment-large size-large wp-image-15151\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image013-2048x1314.png 2048w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image013-600x385.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image013-768x493.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image013-1536x986.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image013-18x12.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aea4f12 elementor-widget elementor-widget-heading\" data-id=\"aea4f12\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 4: Create the workflow and set the trigger to a dynamic SharePoint site<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab8b663 elementor-widget elementor-widget-text-editor\" data-id=\"ab8b663\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In the SharePoint site and list selection, choose Enter custom value, and select the dynamic environment variables we just created.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dcd595b elementor-widget elementor-widget-image\" data-id=\"dcd595b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"435\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image015.png\" class=\"attachment-large size-large wp-image-15152\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image015.png 1372w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image015-600x217.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image015-768x278.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image015-18x7.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f891a59 elementor-widget elementor-widget-heading\" data-id=\"f891a59\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 5: Make a copy of the template from the Power Automate workflow <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-45f2e8c elementor-widget elementor-widget-text-editor\" data-id=\"45f2e8c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Add a \u201cGet file content using path\u201d and a \u201cCreate file\u201d actions from the SharePoint connector in Power Automate.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6e0c2d6 elementor-widget elementor-widget-image\" data-id=\"6e0c2d6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"554\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image017.png\" class=\"attachment-large size-large wp-image-15153\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image017.png 1368w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image017-600x277.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image017-768x354.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image017-18x8.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-47a8fbb elementor-widget elementor-widget-text-editor\" data-id=\"47a8fbb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Use the environment variable for the SharePoint site for both of them<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e299f5a elementor-widget elementor-widget-image\" data-id=\"e299f5a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"662\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image019.png\" class=\"attachment-large size-large wp-image-15154\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image019.png 1381w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image019-600x331.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image019-768x424.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image019-18x10.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b1602d elementor-widget elementor-widget-heading\" data-id=\"7b1602d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 6: Get the drive ID and script ID for the Office Script in each site<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-90635b3 elementor-widget elementor-widget-text-editor\" data-id=\"90635b3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The Run script from SharePoint library action needs workbook location, workbook library, script location, and script library to work.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d5f103 elementor-widget elementor-widget-image\" data-id=\"6d5f103\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"921\" height=\"972\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image021.png\" class=\"attachment-large size-large wp-image-15155\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image021.png 921w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image021-569x600.png 569w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image021-768x811.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image021-11x12.png 11w\" sizes=\"(max-width: 921px) 100vw, 921px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67a04b2 elementor-widget elementor-widget-text-editor\" data-id=\"67a04b2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>For workbook library and script library, we need to get the library<strong> drive id<\/strong>. And for the Office script field we need the item<strong> drive id.<\/strong><\/p><p>One way to get these drive ids is to manually select the script and libraries from the Power Automate and use the code view action.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b350cd elementor-widget elementor-widget-image\" data-id=\"7b350cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"762\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image023.png\" class=\"attachment-large size-large wp-image-15156\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image023.png 1216w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image023-600x381.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image023-768x488.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image023-18x12.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c235bd elementor-widget elementor-widget-heading\" data-id=\"1c235bd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 7: Create text environment variables for the drive ID and script ID<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9cb7a25 elementor-widget elementor-widget-text-editor\" data-id=\"9cb7a25\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Let\u2019s go back to the solution and create two new environment variables. These must be Text type.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8d15cd elementor-widget elementor-widget-code-highlight\" data-id=\"a8d15cd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-javascript line-numbers\">\n\t\t\t\t<code readonly class=\"language-javascript\">\n\t\t\t\t\t<xmp>\u2022\tvar_project_library_drive_ID, with the development drive ID as both the default and current value.\r\n\u2022\tvar_project_office_script_ID, with the development script ID as both the default and current value.\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-32395a1 elementor-widget elementor-widget-image\" data-id=\"32395a1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"618\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image025-2048x1054.png\" class=\"attachment-large size-large wp-image-15157\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image025-2048x1054.png 2048w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image025-600x309.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image025-768x395.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image025-1536x791.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image025-18x9.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c9e74f6 elementor-widget elementor-widget-text-editor\" data-id=\"c9e74f6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Note: if a single automation uses several Office Scripts, creating one environment variable per script ID can be too much so a <strong>configuration table<\/strong> listing all script IDs could be a cleaner approach.<\/p><p>At this point we should have the following environment variables:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6c351db elementor-widget elementor-widget-image\" data-id=\"6c351db\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"248\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image027-2048x424.png\" class=\"attachment-large size-large wp-image-15158\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image027-2048x424.png 2048w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image027-600x124.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image027-768x159.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image027-1536x318.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image027-18x4.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0abe0c elementor-widget elementor-widget-heading\" data-id=\"b0abe0c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 8: Apply the new variables to the Office Script action<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a957b52 elementor-widget elementor-widget-text-editor\" data-id=\"a957b52\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Set the workbook library and script library fields to the drive ID variable, and the script ID field to the script ID variable. It should look as follows<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-245b437 elementor-widget elementor-widget-image\" data-id=\"245b437\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"787\" height=\"666\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image029.png\" class=\"attachment-large size-large wp-image-15159\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image029.png 787w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image029-600x508.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image029-768x650.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image029-14x12.png 14w\" sizes=\"(max-width: 787px) 100vw, 787px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-06cb08b elementor-widget elementor-widget-heading\" data-id=\"06cb08b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 9: (Optional) Fill out parameters, if the office script has input variables<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f55c5b5 elementor-widget elementor-widget-text-editor\" data-id=\"f55c5b5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>When working with environment variables, you\u2019ll be prompted right away to fill out all parameters:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67ab6c6 elementor-widget elementor-widget-image\" data-id=\"67ab6c6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"788\" height=\"477\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image031.png\" class=\"attachment-large size-large wp-image-15160\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image031.png 788w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image031-600x363.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image031-768x465.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image031-18x12.png 18w\" sizes=\"(max-width: 788px) 100vw, 788px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0919788 elementor-widget elementor-widget-text-editor\" data-id=\"0919788\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If instead of straightforward environment variables a configuration table, condition or expression is used, Power Automate can no longer calculate the script\u2019s parameters at build time, so it will not know which are the parameters. In this scenario this is how it should be filled out as follows:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9832036 elementor-widget elementor-widget-image\" data-id=\"9832036\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"232\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image033.png\" class=\"attachment-large size-large wp-image-15161\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image033.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image033-18x7.png 18w\" sizes=\"(max-width: 600px) 100vw, 600px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-efc00db elementor-widget elementor-widget-text-editor\" data-id=\"efc00db\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If no parameters are needed, just input <strong>@{null}<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3478f0d elementor-widget elementor-widget-heading\" data-id=\"3478f0d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 10: Test in the development environment<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-01b3964 elementor-widget elementor-widget-text-editor\" data-id=\"01b3964\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Create a SharePoint item and make sure all runs as expected.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6725d0a elementor-widget elementor-widget-image\" data-id=\"6725d0a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"454\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image035.png\" class=\"attachment-large size-large wp-image-15162\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image035.png 1482w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image035-600x227.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image035-768x291.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image035-18x7.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-407d254 elementor-widget elementor-widget-heading\" data-id=\"407d254\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 11: Prepare and export the solution<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5cca50f elementor-widget elementor-widget-text-editor\" data-id=\"5cca50f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Make sure to add any missing required objects to the solution (e.g., Power Automate connections).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a24d63c elementor-widget elementor-widget-image\" data-id=\"a24d63c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"619\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image037.png\" class=\"attachment-large size-large wp-image-15163\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image037.png 1536w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image037-600x309.png 600w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image037-768x396.png 768w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image037-18x9.png 18w\" sizes=\"(max-width: 1200px) 100vw, 1200px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86c3df4 elementor-widget elementor-widget-text-editor\" data-id=\"86c3df4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Publish all customizations, then go to <strong>Export<\/strong>, choose <strong>Managed solution<\/strong>, and export.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6ac470b elementor-widget elementor-widget-heading\" data-id=\"6ac470b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 12: Import into the production environment<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2e9a41a elementor-widget elementor-widget-text-editor\" data-id=\"2e9a41a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In the production environment, import the solution file. During import, we\u2019ll be prompted to sign in to any required connections, and then to supply the values for each environment variable:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8b8782c elementor-widget elementor-widget-image\" data-id=\"8b8782c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"672\" height=\"805\" src=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image039.png\" class=\"attachment-large size-large wp-image-15164\" alt=\"\" srcset=\"https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image039.png 672w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image039-501x600.png 501w, https:\/\/powergi.net\/wp-content\/uploads\/2026\/07\/image039-10x12.png 10w\" sizes=\"(max-width: 672px) 100vw, 672px\">\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-260d5e6 elementor-widget elementor-widget-heading\" data-id=\"260d5e6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Step 13: Test in production<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-82157a9 elementor-widget elementor-widget-text-editor\" data-id=\"82157a9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Let\u2019s add a new project to the production SharePoint list and confirm the flow runs against the production site, library, and Office Script. All is set now and our environments are completely separate!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fc5d465 elementor-widget elementor-widget-heading\" data-id=\"fc5d465\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Common issues when running Office Scripts in Power Automate<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1719e8e elementor-widget elementor-widget-heading\" data-id=\"1719e8e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Issue 1: Environment variables are not recognized in Power Automate <\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d77139 elementor-widget elementor-widget-text-editor\" data-id=\"1d77139\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>When we just created an environment variable, sometimes Power Automate refuses to recognize them. To fix this, just open the workflow in incognito mode, or wait a few minutes.<\/p><div id=\"seology-cta-2\">\t\t<div data-elementor-type=\"section\" data-elementor-id=\"7280\" class=\"elementor elementor-7280\" data-elementor-post-type=\"elementor_library\">\n\t\t\t<div class=\"elementor-element elementor-element-7e3f164 e-con-full e-flex e-con e-parent\" data-id=\"7e3f164\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"background_background\":\"classic\",\"jet_parallax_layout_list\":[]}'>\n\t\t<div class=\"elementor-element elementor-element-9078c9f e-con-full e-flex e-con e-child\" data-id=\"9078c9f\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b99949 elementor-widget elementor-widget-heading\" data-id=\"7b99949\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Automate tasks that slow you down<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e61db5 elementor-widget elementor-widget-heading\" data-id=\"8e61db5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Free up your team\u2019s time and focus on strategic work with digital and robotic automation.<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a578907 e-flex e-con-boxed e-con e-child\" data-id=\"a578907\" data-element_type=\"container\" data-e-type=\"container\" data-settings='{\"jet_parallax_layout_list\":[]}'>\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e8c827b elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"e8c827b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#ctc_chat\">\n\t\t\t<i aria-hidden=\"true\" class=\"fab fa-whatsapp\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d834237 elementor-view-stacked elementor-shape-circle elementor-widget elementor-widget-icon\" data-id=\"d834237\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"https:\/\/powergi.net\/de\/contact\/\">\n\t\t\t<i aria-hidden=\"true\" class=\"far fa-envelope\"><\/i>\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<\/div><p>Also make sure that the Power Automate workflow is part of the solution.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f73fe83 elementor-widget elementor-widget-heading\" data-id=\"f73fe83\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Issue 2: List environment variables don't work for Office Script library\/script fields<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e79e02b elementor-widget elementor-widget-text-editor\" data-id=\"e79e02b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The Office Script action\u2019s workbook and script library fields expect a <strong>drive ID<\/strong>, while the standard SharePoint list-type environment variable stores a different GUID (the library ID as Power Automate represents it elsewhere). So unfortunately, Data source environment variables can\u2019t be used for Excel automations, Text type values with the drive id are the solution for this issue.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef1c4e9 elementor-widget elementor-widget-heading\" data-id=\"ef1c4e9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Issue 3: Script parameters and values get cleared when switching the SharePoint site field<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-865052f elementor-widget elementor-widget-text-editor\" data-id=\"865052f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If at some point we had a workflow that had hardcoded values in the SharePoint and file selection, once the SharePoint site field on the Office Script action is changed to a dynamic value, the values are cleared out in the modern editor. Having a window open with a duplicate of the workflow can help so we don\u2019t have to remember everything.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3de00e8 elementor-widget elementor-widget-heading\" data-id=\"3de00e8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Issue 4: Script parameters collapse into a single field with conditional logic<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7668efc elementor-widget elementor-widget-text-editor\" data-id=\"7668efc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If expressions or conditions are used in the office script action, the individual parameter fields disappear and are replaced by one combined field.<\/p><p>The fix to this is entering a JSON payload with the parameter names or use @{null} if the script doesn\u2019t have parameters.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-25d69ba elementor-widget elementor-widget-heading\" data-id=\"25d69ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Best Practices for Office Script ALM and Handover<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4b67f82 elementor-widget elementor-widget-text-editor\" data-id=\"4b67f82\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Some key points to remember when working with Power Automate and Office Scripts across different environment are:<\/p><ul><li>Try to keep SharePoint site structures identical across environments. Same library names, folder names, and file names in development, QA (testing) and production.<\/li><li>Upload the Office Script and template to every SharePoint site.<\/li><li>Use environment variables for anything that changes between environments (SharePoint site, list, drive ID, and script ID)<\/li><li>Consider a configuration table instead of individual environment variables if your solution involves more than a couple of Office Scripts, to keep things maintainable.<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f8343c4 elementor-widget elementor-widget-heading\" data-id=\"f8343c4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Build environment-aware Power Automate solutions with PowerGI<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-34611b7 elementor-widget elementor-widget-text-editor\" data-id=\"34611b7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If you\u2019re working with Excel automations and need some help setting up the correct configuration for environment separation, we\u2019d love to have a conversation and see how we can help you implement ALM practices with our\u00a0<a href=\"https:\/\/powergi.net\/power-automate-consulting-services\/\" target=\"_blank\">Power Automate consulting services<\/a>. <a href=\"https:\/\/powergi.net\/contact\/\">Contact us<\/a> and let\u2019s discover the joy of automation together!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Table of Contents What are environment-aware Office Scripts in Power Automate? When building a Power Automate flow that runs an Office Script, the Power Automation prompts for the SharePoint site, the document library, the list name, and the script and workbook IDs, which by default lets makers select from a dropdown of folder selection: Above [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":15205,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"glossary_letter":"a","footnotes":""},"categories":[172,85],"tags":[],"class_list":["post-15145","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dpa","category-power-automate-cat"],"glossary_letter":"a","rank_math_title":"Run Office Scripts in Power Automate Across Environments","rank_math_description":"Learn how to run Office Scripts in Power Automate across development, test, and production using SharePoint, Script IDs, and environment variables.","rank_math_focus_keyword":"Office Scripts in Power Automate","_links":{"self":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts\/15145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/comments?post=15145"}],"version-history":[{"count":13,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts\/15145\/revisions"}],"predecessor-version":[{"id":15202,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/posts\/15145\/revisions\/15202"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/media\/15205"}],"wp:attachment":[{"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/media?parent=15145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/categories?post=15145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/powergi.net\/de\/wp-json\/wp\/v2\/tags?post=15145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}