{"id":513,"date":"2024-01-12T15:39:34","date_gmt":"2024-01-12T14:39:34","guid":{"rendered":"https:\/\/www.paalolav.no\/?p=513"},"modified":"2024-02-28T15:26:05","modified_gmt":"2024-02-28T14:26:05","slug":"making-the-image-column-in-a-sharepoint-useful-to-me","status":"publish","type":"post","link":"https:\/\/www.paalolav.no\/?p=513","title":{"rendered":"Making the Image column in a SharePoint more useful [to me]"},"content":{"rendered":"\n<p>Say you want to build a &#8220;call-to-action&#8221; type functionality with Audience Targeting to your SharePoint intranet utilizing PnP Modern Search &#8211; maybe something like this:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-12-at-13.22.51-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"351\" src=\"https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-12-at-13.22.51-2-1024x351.png\" alt=\"\" class=\"wp-image-519\" srcset=\"https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-12-at-13.22.51-2-1024x351.png 1024w, https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-12-at-13.22.51-2-300x103.png 300w, https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-12-at-13.22.51-2-768x264.png 768w, https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/01\/Screenshot-2024-01-12-at-13.22.51-2.png 1285w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p>A natural place to store the text and publishing values in a list. And since we now have the Image column, it seems like a natural place to place an image we can call up, right? No. Because Microsoft.<\/p>\n\n\n\n<p>How do we solve this?<br><strong>We use the Power Platform!<\/strong><\/p>\n\n\n\n<p>Below is a Logic App that reads the list for changes, fetches the image url from the list column and writes that back to the list.<\/p>\n\n\n\n<p>Remember to add a hidden StopRun column with &#8220;Append Changes to Existing Text&#8221; to avoid a feedback loop in your automation!<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/02\/Screenshot-2024-01.png\"><img loading=\"lazy\" decoding=\"async\" width=\"608\" height=\"897\" src=\"https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/02\/Screenshot-2024-01.png\" alt=\"\" class=\"wp-image-526\" style=\"width:650px;height:auto\" srcset=\"https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/02\/Screenshot-2024-01.png 608w, https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/02\/Screenshot-2024-01-203x300.png 203w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/02\/Screenshot-2024-02.png\"><img loading=\"lazy\" decoding=\"async\" width=\"608\" height=\"967\" src=\"https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/02\/Screenshot-2024-02.png\" alt=\"\" class=\"wp-image-527\" srcset=\"https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/02\/Screenshot-2024-02.png 608w, https:\/\/www.paalolav.no\/wp-content\/uploads\/2024\/02\/Screenshot-2024-02-189x300.png 189w\" sizes=\"(max-width: 608px) 100vw, 608px\" \/><\/a><\/figure>\n\n\n\n<p>Hope that this will bring you joy to your solution!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Say you want to build a &#8220;call-to-action&#8221; type functionality with Audience Targeting to your SharePoint intranet utilizing PnP Modern Search &#8211; maybe something like this: A natural place to store the text and publishing values in a list. And since we now have the Image column, it seems like a natural place to place an [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":518,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86,70,69,78,67,87],"tags":[],"class_list":["post-513","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-automations","category-intranet","category-it","category-logic-apps","category-sharepoint","category-pnp-modern-search"],"_links":{"self":[{"href":"https:\/\/www.paalolav.no\/index.php?rest_route=\/wp\/v2\/posts\/513"}],"collection":[{"href":"https:\/\/www.paalolav.no\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.paalolav.no\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.paalolav.no\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.paalolav.no\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=513"}],"version-history":[{"count":3,"href":"https:\/\/www.paalolav.no\/index.php?rest_route=\/wp\/v2\/posts\/513\/revisions"}],"predecessor-version":[{"id":528,"href":"https:\/\/www.paalolav.no\/index.php?rest_route=\/wp\/v2\/posts\/513\/revisions\/528"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.paalolav.no\/index.php?rest_route=\/wp\/v2\/media\/518"}],"wp:attachment":[{"href":"https:\/\/www.paalolav.no\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.paalolav.no\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.paalolav.no\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}