{"id":107,"date":"2024-09-06T13:04:28","date_gmt":"2024-09-06T20:04:28","guid":{"rendered":"https:\/\/gilosoftblogcom.wordpress.com\/?p=107"},"modified":"2024-09-06T13:04:28","modified_gmt":"2024-09-06T20:04:28","slug":"automate-file-property-updates-in-sharepoint-using-power-automate","status":"publish","type":"post","link":"https:\/\/blog.gilosoft.com\/index.php\/2024\/09\/06\/automate-file-property-updates-in-sharepoint-using-power-automate\/","title":{"rendered":"Automate File Property Updates in SharePoint using Power Automate"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In order for you to get the most out of SharePoint as a document managing tool you want to keep your file&#8217;s properties up to date. Using Power Automate and the REST API in SharePoint can do this for you in a more efficient way.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog we will go over the steps to creating a flow in Power Automate to update file properties in SharePoint.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 1:<\/strong>&nbsp;Create A New Flow in Power Automate<br>Navigate to Power Automate and create an instant cloud flow with a manual trigger.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"823\" height=\"524\" src=\"https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.57.36e280afpm.png?w=823\" alt=\"\" class=\"wp-image-109\" srcset=\"https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.57.36e280afpm.png 823w, https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.57.36e280afpm-300x191.png 300w, https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.57.36e280afpm-768x489.png 768w\" sizes=\"auto, (max-width: 823px) 100vw, 823px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 2:<\/strong>&nbsp;Create 4 Compose action cards to hold your Doc Site URL, Site-Relative-Path, Library Name, and Status.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"550\" src=\"https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.55.54e280afpm.png?w=555\" alt=\"\" class=\"wp-image-110\" srcset=\"https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.55.54e280afpm.png 555w, https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.55.54e280afpm-300x297.png 300w, https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.55.54e280afpm-150x150.png 150w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 3:<\/strong>&nbsp;Get File Properties<br>Add a &#8220;Get file properties&#8221; action card and fill the Site address and Document library with Outputs from the Compose Action cards.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"243\" src=\"https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.56.09e280afpm.png?w=555\" alt=\"\" class=\"wp-image-112\" srcset=\"https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.56.09e280afpm.png 555w, https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.56.09e280afpm-300x131.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 4:<\/strong>&nbsp;Add a &#8220;Apply to each&#8221; action card with the following details:<br>Compose action card(File-Property): Current item<br>Compose action card(File-ID): item()?[&#8216;ID&#8217;]<br>Send an HTTP request to SharePoint action card: with the details in step 5<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"579\" height=\"857\" src=\"https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.56.35e280afpm.png?w=579\" alt=\"\" class=\"wp-image-113\" srcset=\"https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.56.35e280afpm.png 579w, https:\/\/blog.gilosoft.com\/wp-content\/uploads\/2024\/09\/screenshot-2024-09-06-at-12.56.35e280afpm-203x300.png 203w\" sizes=\"auto, (max-width: 579px) 100vw, 579px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 5:<\/strong>&nbsp;Send an HTTP Request to SharePoint<br>Add a &#8220;Send an HTTP request to SharePoint&#8221; action card and configure it with the following details:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSite Address: The URL of your SharePoint site.\nMethod: POST\nUri: _api\/web\/lists\/getbytitle(Outputs expression)\/items(Outputs expression)\nHeaders:\n{\n  &quot;Accept&quot;: &quot;application\/json;odata=verbose&quot;,\n  &quot;Content-Type&quot;: &quot;application\/json;odata=verbose&quot;,\n  &quot;X-HTTP-Method&quot;: &quot;MERGE&quot;,\n  &quot;IF-MATCH&quot;: &quot;*&quot;\n}\nBody:\n{\n  &quot;__metadata&quot;: {\n    &quot;type&quot;: &quot;SP.Data.OutputsItem&quot;\n  },\n &quot;FlowTrigger&quot;:&quot;Start Flow&quot;,\n &quot;DocumentStatus&quot;:&quot;Outputs&quot;\n}\n<\/pre><\/div>\n\n\n<h4 class=\"wp-block-heading\"><\/h4>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In order for you to get the most out of SharePoint as a document managing tool you want to keep your file&#8217;s properties up to date. Using Power Automate and the REST API in SharePoint can do this for you in a more efficient way. In this blog we will go over the steps to [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":115,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-107","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate-text-functions"],"_links":{"self":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts\/107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/comments?post=107"}],"version-history":[{"count":0,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts\/107\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/media\/115"}],"wp:attachment":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/media?parent=107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/categories?post=107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/tags?post=107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}