![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/UploadDoc.jpg\")
<\/figure>\n\n\n\n- SharePoint List with a custom column \u201cProperty1\u201d (Single Line of Text)<\/strong><\/li>
- SharePoint Document Library with a custom column \u201cProperty1\u201d (Single Line of Text)<\/strong><\/li>
- A Flow in Power Automate<\/strong><\/li>
- A PowerApp<\/strong><\/li><\/ul>\n\n\n\n
The Flow<\/h2>\n\n\n\n
First, we need a trigger. In our case we will use \u201cWhen item is created\u201d from a SharePoint List.<\/p>\n\n\n\n
Second step is to get all attachments. Why multiple!? Because it is possible to upload multiple documents with the functionality and we have to catch that case.<\/p>\n\n\n\n
![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP1.jpg\")
<\/figure>\n\n\n\nAfterwards we must loop through each attachment object. The first action in the loop is \u201cGet Attachment content\u201d, with that data we can create a file as a next step. The last step would be to update the file properties. In our case it is a simple Single Line of Text field, but for sure it can be any type of column.<\/p>\n\n\n\n
![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP22.jpg\")
<\/figure>\n\n\n\nIt is a simple and straight forward Flow:<\/p>\n\n\n\n
![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-912x1024.jpg\")
<\/figure>\n\n\n\nPowerApp<\/h2>\n\n\n\n
The last step in our use case would be to integrate the functionality into a Canvas PowerApp. For that, we have to insert a form for the created SharePoint List.<\/p>\n\n\n\n
- Insert a Datasource – SharePoint<\/li>
- Select the corresponding SharePoint site<\/li>
- Select the created custom list <\/li>
- Insert an Edit Form via the Insert tab – Forms<\/li>
- Select the list as a DataSource on the property pane on the right side<\/li>
- Change the default Mode to New in the property pane<\/li><\/ul>\n\n\n\n
![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/PA1.jpg\")
<\/figure>\n\n\n\n- Add a button and insert the function for the property “onSelect” – SubmitForm(Form1);NewForm(Form1);<\/li><\/ul>\n\n\n\n
![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/PA2.jpg\")
<\/figure>\n\n\n\n- To get a feedback we change in the form the property “OnSuccess” – Notify(“Successfully uploaded”, NotificationType.Success)<\/li><\/ul>\n\n\n\n
![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/PA3.jpg\")
<\/figure>\n\n\n\n- Test it \ud83d\ude42<\/li><\/ul>\n\n\n\n
![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/p4.jpg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/pa5.jpg\")
<\/figure>\n\n\n\nThe final result can be seen in the document library. <\/p>\n\n\n\n
![\"\"](\"https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/doclib.jpg\")
<\/figure>\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Due to the fact, that it is currently not possible to simply integrate an upload functionality for a document library, I searched for alternate solutions. In detail, an upload and passing Metadata to a SharePoint document library is divided in two steps. First you must upload a document to the library. Afterwards you can update the metadata information. That would […]<\/p>\n","protected":false},"author":1,"featured_media":56,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[3,4,2],"tags":[17,13,18],"class_list":["post-50","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-apps","category-power-automate","category-power-plattform","tag-powerapps","tag-powerautomate","tag-uploaddocument"],"uagb_featured_image_src":{"full":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3.jpg",1054,1183,false],"thumbnail":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-150x150.jpg",150,150,true],"medium":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-267x300.jpg",267,300,true],"medium_large":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-768x862.jpg",640,718,true],"large":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-912x1024.jpg",640,719,true],"elegant_blocks_team_1":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-500x500.jpg",500,500,true],"elegant_blocks_blog_1":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-693x462.jpg",693,462,true],"elegant_blocks_slider_1":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-1054x1000.jpg",1054,1000,true],"1536x1536":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3.jpg",1054,1183,false],"2048x2048":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3.jpg",1054,1183,false],"bizberg_medium":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-300x300.jpg",300,300,true],"bizberg_gallery":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-500x400.jpg",500,400,true],"bizberg_blog_list":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-368x240.jpg",368,240,true],"bizberg_detail_image":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-825x400.jpg",825,400,true],"bizberg_detail_image_no_sidebar":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-920x400.jpg",920,400,true],"bizberg_portfolio_homepage":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-600x400.jpg",600,400,true],"bizberg_blog_list_no_sidebar_1":["https:\/\/m365-blog.de\/wp-content\/uploads\/2020\/06\/FlowP3-220x190.jpg",220,190,true]},"uagb_author_info":{"display_name":"m365admin","author_link":"https:\/\/m365-blog.de\/?author=1"},"uagb_comment_info":4,"uagb_excerpt":"Due to the fact, that it is currently not possible to simply integrate an upload functionality for a document library, I searched for alternate solutions. In detail, an upload and passing Metadata to a SharePoint document library is divided in two steps. First you must upload a document to the library. Afterwards you can update…","_links":{"self":[{"href":"https:\/\/m365-blog.de\/index.php?rest_route=\/wp\/v2\/posts\/50","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/m365-blog.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/m365-blog.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/m365-blog.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/m365-blog.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=50"}],"version-history":[{"count":1,"href":"https:\/\/m365-blog.de\/index.php?rest_route=\/wp\/v2\/posts\/50\/revisions"}],"predecessor-version":[{"id":63,"href":"https:\/\/m365-blog.de\/index.php?rest_route=\/wp\/v2\/posts\/50\/revisions\/63"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/m365-blog.de\/index.php?rest_route=\/wp\/v2\/media\/56"}],"wp:attachment":[{"href":"https:\/\/m365-blog.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=50"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m365-blog.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=50"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m365-blog.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Test it \ud83d\ude42<\/li><\/ul>\n\n\n\n
- To get a feedback we change in the form the property “OnSuccess” – Notify(“Successfully uploaded”, NotificationType.Success)<\/li><\/ul>\n\n\n\n
- Add a button and insert the function for the property “onSelect” – SubmitForm(Form1);NewForm(Form1);<\/li><\/ul>\n\n\n\n
- SharePoint Document Library with a custom column \u201cProperty1\u201d (Single Line of Text)<\/strong><\/li>