{"id":2857,"date":"2022-03-29T16:53:00","date_gmt":"2022-03-29T14:53:00","guid":{"rendered":"https:\/\/www.itidea.nl\/?p=2857"},"modified":"2022-04-01T16:54:15","modified_gmt":"2022-04-01T14:54:15","slug":"power-automate-update-dynamic-sharepoint-item","status":"publish","type":"post","link":"https:\/\/www.itidea.nl\/index.php\/power-automate-update-dynamic-sharepoint-item\/","title":{"rendered":"Power Automate Update Dynamic SharePoint Item"},"content":{"rendered":"\n

In flows I like to use dynamic inputs for Site Address and List Name in actions like ‘Update item’ so I can enter these values once and reuse them throughout the entire flow. Another advantage is being able to easily switch between sites and lists because they are only defined once.<\/p>\n\n\n\n

The Update item action requests four input fields: Site Addres, List Name, Id and Item. The first three are dynamic, the last one is maybe a bit tricky. The hint text says ‘Item with changed properties’, but what does that mean?<\/p>\n\n\n\n

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

It expects a JSON representation of the field(s) which will get an update.<\/p><\/blockquote>\n\n\n\n

An easy way to enter the JSON is to use the Compose action. The output of the Compose action can be used in the Item field of de Update item action.<\/p>\n\n\n\n

The picture belows shows a Compose action with JSON in it to set the field with the internal or static name of ITIdea_Active to false.<\/p>\n\n\n\n

Then an Update item action has been placed to connect to the site, list and appropriate Id of the item to update.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"

In flows I like to use dynamic inputs for Site Address and List Name in actions like ‘Update item’ so I can enter these values once and reuse them throughout the entire flow. Another advantage is being able to easily … Read More »<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,54,41],"tags":[37],"class_list":["post-2857","post","type-post","status-publish","format-standard","hentry","category-office-365","category-power-automate","category-sharepoint","tag-office365"],"_links":{"self":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/2857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/comments?post=2857"}],"version-history":[{"count":2,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/2857\/revisions"}],"predecessor-version":[{"id":2861,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/2857\/revisions\/2861"}],"wp:attachment":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/media?parent=2857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/categories?post=2857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/tags?post=2857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}