{"id":110871,"date":"2017-08-25T06:30:59","date_gmt":"2017-08-25T13:30:59","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/"},"modified":"2017-08-25T06:30:59","modified_gmt":"2017-08-25T13:30:59","slug":"support-for-sharepoint-document-library-properties","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/","title":{"rendered":"Support for SharePoint Document Library Properties"},"content":{"rendered":"<p>In a <a href=\"https:\/\/flow.microsoft.com\/en-us\/blog\/setting-sharepoint-s-person-choice-and-lookup-fields\/\"><u>blog post<\/u><\/a> earlier this month, we announced read-write support for Person, Choice, and Lookup fields. This week, we\u2019re pleased to announce another <a href=\"https:\/\/powerusers.microsoft.com\/t5\/Flow-Ideas\/SharePoint-Files-all-fields-not-just-a-few\/idi-p\/2882\"><u>highly requested feature<\/u><\/a> in the SharePoint connector \u2013 <strong>support for document library properties<\/strong>.<\/p>\n<p>This support comes in the form of two new triggers &#8211; When a file is created (properties only) and When a file is created or modified (properties only) and three new actions \u2013 Get file properties, Get files (properties only) and Update file properties.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic0.png\"\/><\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic1.png\"\/><\/p>\n<p style=\"margin: 0in 0in 8pt;\">In this blog post, we\u2019ll walk you through a detailed example of how to use these triggers and actions. We\u2019ll also use this opportunity to introduce you to a couple of additional properties that have been added to ease your flow building experience.<\/p>\n<h1 style=\"margin: 12pt 0in 0pt;\">File Triggers and Actions<\/h1>\n<p style=\"margin: 0in 0in 8pt;\">Let\u2019s suppose you have a document library for housing legal documents. In this library, you\u2019ve added a Person column to track a document\u2019s owner. <\/p>\n<p style=\"margin: 0in 0in 8pt;\"><img decoding=\"async\" alt=\"\" src=\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic2.png\"\/><\/p>\n<p>Let\u2019s create a flow that will:<\/p>\n<ul>\n<li>\n<p>Notify the Chief Legal Officer and assign him\/her as the owner whenever a new document is added.<\/p>\n<\/li>\n<li>\n<p>Notify the owner whenever a document is modified<\/p>\n<\/li>\n<\/ul>\n<p>To do so, create a flow from blank and add the trigger \u2013 <strong>When a file is created or modified (properties only).<\/strong> Notice how this trigger contains a <strong>Library Name<\/strong> field which enumerates all the document libraries in your site.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic3.png\"\/><\/p>\n<p>Now add a <strong>Condition<\/strong> where you check whether the <strong>[Modified]<\/strong> property is equal to the <strong>[Created] <\/strong>property. If it is, then this is a new document. If it\u2019s not, then it\u2019s a modified document.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic4.png\"\/><\/p>\n<p>In the <strong>If yes<\/strong> branch (new document), add a <strong>Send email <\/strong>action. When you select the To field in the Dynamic content dialog, you\u2019ll see all the fields in your document library including the Owner field which is further broken down into properties such as Owner DisplayName, Owner Email, Owner JobTitle, etc. Set the <strong>To<\/strong> field to the Chief Legal Officer, the <strong>Subject<\/strong> to \u201cNew document added &#8211; <strong>[Name]<\/strong>,\u201d and the <strong>Email Body<\/strong> to \u201c<strong>[Link to Item].\u201d <\/strong>Name and Link to Item are additional properties we\u2019ve made available (more on this further down in the post).<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic5.png\"\/><\/p>\n<p>After the Send email action, add the <strong>Update file properties<\/strong> action. This allows you to update the properties of a file. If you want to update the contents, use the Update file action. Match the Site Address and Library Name with the values entered in the trigger. Set the Id field to the [ID] of the uploaded file. For the Owner Claims field, select from the list of users or enter a custom value.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic6.png\"\/><\/p>\n<p>In the No branch (modified document), send an email to the Owner letting them know that a file they own has been modified and include a link to the item. In this case, we\u2019re using the Owner Email field which is a property of the document library and the Name and Link to item properties.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic7.png\"\/><\/p>\n<h1>Additional Properties<\/h1>\n<p>In this release, we\u2019ve appended some new properties to triggers and actions to make SharePoint items easier to use in Flow and PowerApps. These properties are not direct visible in SharePoint. The full list is below:<\/p>\n<ul>\n<li>\n<p>Name \u2013 file name of the item in document libraries, display name of the item in lists<\/p>\n<\/li>\n<li>\n<p>Folder path \u2013 Path to the folder the item is in, relative to the site address<\/p>\n<\/li>\n<li>\n<p>Identifier \u2013 Value that can be used in file related actions for selecting a file<\/p>\n<\/li>\n<li>\n<p>Link to item \u2013 Link that can be used to get to the file or list item. Only people with permissions to the item will be able to open the link.<\/p>\n<\/li>\n<\/ul>\n<h1>Known issue<\/h1>\n<p>We are working on adding the item ID as an output of the Create File action, so that you can use it in conjunction with the Update file properties.<\/p>\n<h1>Onwards we go<\/h1>\n<p>The SharePoint + Flow story continues to be a high priority for us and we (can\u2019t stop) won\u2019t stop until we\u2019ve ensured Flow is a worthy successor to SharePoint Designer workflows. As always, share your feedback using the comments below. If you have a question or an idea, head over to the <a href=\"https:\/\/powerusers.microsoft.com\/t5\/Microsoft-Flow-Community\/ct-p\/FlowCommunity\"><u>Microsoft Flow Community<\/u><\/a>.<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Flow now gives you the ability to read and set SharePoint document library properties. Check out this post to learn more about how to use these highly requested features.   <\/p>\n","protected":false},"author":350,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2752,2836],"power-automate-tag":[2556,2754,2777],"coauthors":[2911],"class_list":["post-110871","power-automate","type-power-automate","status-publish","hentry","power-automate-category-product-updates","power-automate-category-walkthroughs","power-automate-tag-document-libraries","power-automate-tag-properties","power-automate-tag-sharepoint"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Support for SharePoint Document Library Properties - 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\/power-automate\/support-for-sharepoint-document-library-properties\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Support for SharePoint Document Library Properties - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Flow now gives you the ability to read and set SharePoint document library properties. Check out this post to learn more about how to use these highly requested features.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic0.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Merwan Hade\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/\",\"name\":\"Support for SharePoint Document Library Properties - 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\/power-automate\/support-for-sharepoint-document-library-properties\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic0.png\",\"datePublished\":\"2017-08-25T13:30:59+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/#primaryimage\",\"url\":\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic0.png\",\"contentUrl\":\"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic0.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Support for SharePoint Document Library Properties\"}]},{\"@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\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Support for SharePoint Document Library Properties - 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\/power-automate\/support-for-sharepoint-document-library-properties\/","og_locale":"en_US","og_type":"article","og_title":"Support for SharePoint Document Library Properties - Microsoft Power Platform Blog","og_description":"Flow now gives you the ability to read and set SharePoint document library properties. Check out this post to learn more about how to use these highly requested features.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic0.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 min read","Written by":"Merwan Hade"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/","name":"Support for SharePoint Document Library Properties - 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\/power-automate\/support-for-sharepoint-document-library-properties\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/#primaryimage"},"thumbnailUrl":"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic0.png","datePublished":"2017-08-25T13:30:59+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/#primaryimage","url":"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic0.png","contentUrl":"https:\/\/flowblogimagesandfiles.blob.core.windows.net\https://www.microsoft.com/images\/DocumentLibraryProperties\/pic0.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/support-for-sharepoint-document-library-properties\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Support for SharePoint Document Library Properties"}]},{"@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\/"}}]}},"msxcm_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\/power-automate\/110871","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/350"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110871"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110871\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110871"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=110871"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110871"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110871"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}