{"id":440,"date":"2020-12-08T06:26:37","date_gmt":"2020-12-08T06:26:37","guid":{"rendered":"http:\/\/fredborg.org\/?p=440"},"modified":"2020-12-23T20:43:50","modified_gmt":"2020-12-23T20:43:50","slug":"let-us-talk-powerautomate-part-1-files-from-business-central-to-sharepoint","status":"publish","type":"post","link":"https:\/\/fredborg.org\/?p=440","title":{"rendered":"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">First&nbsp;off,&nbsp;I will start with a disclaimer, I am not a Power Automate guru, but I thought that it was about time that I spend some time to learn the ropes, and then I thought why not share my journey with you, so we can learn together&nbsp;&#x1f60a;&nbsp;&nbsp;<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">What is Power Automate and why should I care?&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Well, unless you are totally new to the world of Microsoft development you have properly heard about Microsoft Flow, well Power Automate is Microsoft Flow just rebranded to fit into their new Power Platform &#x1f60e; . When we talk about Power&nbsp;Automate&nbsp;we talk about automating different workflows, and the power of Power Automate comes in its simplicity&#x1f4aa; , because you can do pretty much anything with a few clicks and by using some of their many build-in templates. One of the many strengths is its easy integration into anything Microsoft, in only using a few clicks you can have a webservice up and running that will let you place a file on a SharePoint, one drive or FTP server.&nbsp; So, the reason why you should care about Power Automate is that it will make your life a whole lot easier, and your customers much happier since everything can be done in no time&#x1f929; .&nbsp;<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">From Business Central to SharePoint&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this first post we will&nbsp;take a look&nbsp;at how we can easily take any file and place it on a SharePoint site, now I will show you how you can do this from Business Central, but you can call the REST webservice from any programming or scripting language.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First thing you have to do is go to&nbsp;<a href=\"https:\/\/flow.microsoft.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/flow.microsoft.com<\/a>&nbsp;and create an account or sing in with you existing Microsoft Account. Then go to create.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"201\" height=\"508\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-1.png\" alt=\"\" class=\"wp-image-441\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-1.png 201w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-1-119x300.png 119w\" sizes=\"auto, (max-width: 201px) 100vw, 201px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">And here you&nbsp;have the ability to&nbsp;choose either some build in flows, or to create your own, we will go with an Instant flow.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"224\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-2.png\" alt=\"\" class=\"wp-image-442\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-2.png 1024w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-2-300x66.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-2-768x168.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Next choose the trigger called&nbsp;<strong>When an Http request is received<\/strong>&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"442\" height=\"550\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-3.png\" alt=\"\" class=\"wp-image-443\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-3.png 442w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-3-241x300.png 241w\" sizes=\"auto, (max-width: 442px) 100vw, 442px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Click the trigger and create your json body and choose Post:&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"603\" height=\"469\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-4.png\" alt=\"\" class=\"wp-image-444\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-4.png 603w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-4-300x233.png 300w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/figure><\/div>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\n{ \n\n    &quot;type&quot;: &quot;object&quot;, \n    &quot;properties&quot;: { \n        &quot;ApiToken&quot;: { \n            &quot;type&quot;: &quot;string&quot; \n        }, \n        &quot;FileName&quot;: { \n            &quot;type&quot;: &quot;string&quot; \n        }, \n        &quot;Document&quot;: { \n            &quot;type&quot;: &quot;string&quot; \n        } \n    } \n} \n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">In my pay load I will take en API Token for security, the filename and Document which will be my Base64 encoded string.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Next click New Step and choose Control, and then condition&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"644\" height=\"172\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-6.png\" alt=\"\" class=\"wp-image-448\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-6.png 644w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-6-300x80.png 300w\" sizes=\"auto, (max-width: 644px) 100vw, 644px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"604\" height=\"266\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-8.png\" alt=\"\" class=\"wp-image-447\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-8.png 604w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-8-300x132.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"236\" height=\"262\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-5.png\" alt=\"\" class=\"wp-image-445\"\/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Next&nbsp;we will control that our token is correct, so choose&nbsp;ApiToken&nbsp;and then a strong token.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"599\" height=\"224\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-7.png\" alt=\"\" class=\"wp-image-446\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-7.png 599w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-7-300x112.png 300w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Now if this webservice is called with the correct token you should upload the file to SharePoint so in the<strong> If Yes<\/strong> box choose add action.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"647\" height=\"225\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-9.png\" alt=\"\" class=\"wp-image-449\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-9.png 647w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-9-300x104.png 300w\" sizes=\"auto, (max-width: 647px) 100vw, 647px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">And find the create file.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"285\" height=\"493\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-10.png\" alt=\"\" class=\"wp-image-450\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-10.png 285w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-10-173x300.png 173w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Power Automate will then use your user to find which SharePoint sites you have access to, choose one and a folder in file name choose&nbsp;FileName.&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"607\" height=\"323\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-11.png\" alt=\"\" class=\"wp-image-451\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-11.png 607w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-11-300x160.png 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">In File content go to Expression and write&nbsp;<strong>base64ToBinary(triggerBody()?[&#8216;Document&#8217;])&nbsp;<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So,&nbsp;it should look something like this:&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"646\" height=\"362\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-13.png\" alt=\"\" class=\"wp-image-453\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-13.png 646w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-13-300x168.png 300w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">And that is it you now have a REST service created in Power Automate to place a file on your SharePoint, now give you flow a name and save it.&nbsp;&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"80\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-12.png\" alt=\"\" class=\"wp-image-452\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-12.png 1024w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-12-300x23.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-12-768x60.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Here you might be meet with some billing restrictions, unfortunately Power Automate is not free&nbsp;&#x1f641;&nbsp;However once you have&nbsp;choose&nbsp;you plan you can start testing your flow with Postman.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can then call the webservice with something like this:&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"277\" src=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-14.png\" alt=\"\" class=\"wp-image-454\" srcset=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-14.png 771w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-14-300x108.png 300w, https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/image-14-768x276.png 768w\" sizes=\"auto, (max-width: 771px) 100vw, 771px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">And you Power Automate will then create your file on your SharePoint destination.&nbsp;&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Next you will have to create the rest webservice call from Business central, which could be done with the following code:&nbsp;<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: as3; title: ; notranslate\" title=\"\">\nprocedure SendToFlow(FileName: Text; Base64: Text) \n\n    Var \n        client: HttpClient; \n        cont: HttpContent; \n        header: HttpHeaders; \n        response: HttpResponseMessage; \n        Jobject: JsonObject; \n        tmpString: Text; \n    Begin \n        Jobject.Add(&#039;ApiToken&#039;, \u2018{token}\u2019); \n        Jobject.Add(&#039;Document&#039;, Base64); \n        Jobject.Add(&#039;FileName&#039;, FileName); \n        Jobject.WriteTo(tmpString); \n        cont.WriteFrom(tmpString); \n        cont.ReadAs(tmpString); \n        cont.GetHeaders(header); \n        header.Remove(&#039;Content-Type&#039;); \n        header.Add(&#039;Content-Type&#039;, &#039;application\/json&#039;); \n\n        client.Post(\u2018{ flow url}\u2019, cont, response); \n\n    end; \n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">And we are done, so something that would&nbsp;normally&nbsp;take I do not know how many hours to do the old fashion way &#x1f60f;, can now be completed in 30&nbsp;minutes&nbsp;of coding &#x1f92f; , that was it for this time, stay tuned as I try to dig more into what we can do with Power Automate, and until next time stay safe.&nbsp;&#x1f637;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>First&nbsp;off,&nbsp;I will start with a disclaimer, I am not a Power Automate guru, but I thought that it was about&#8230; <a class=\"read-more\" href=\"https:\/\/fredborg.org\/?p=440\" rel=\"nofollow\"> Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":458,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,4,1],"tags":[],"class_list":["post-440","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-central","category-power-automate","category-uncategorized","shapla-grid-item"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint) - Fredborg<\/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:\/\/fredborg.org\/?p=440\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint) - Fredborg\" \/>\n<meta property=\"og:description\" content=\"First&nbsp;off,&nbsp;I will start with a disclaimer, I am not a Power Automate guru, but I thought that it was about... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fredborg.org\/?p=440\" \/>\n<meta property=\"og:site_name\" content=\"Fredborg\" \/>\n<meta property=\"article:published_time\" content=\"2020-12-08T06:26:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-23T20:43:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dfredborg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dfredborg\" \/>\n<meta name=\"twitter:site\" content=\"@dfredborg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dfredborg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fredborg.org\/?p=440#article\",\"isPartOf\":{\"@id\":\"https:\/\/fredborg.org\/?p=440\"},\"author\":{\"name\":\"dfredborg\",\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"headline\":\"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint)\",\"datePublished\":\"2020-12-08T06:26:37+00:00\",\"dateModified\":\"2020-12-23T20:43:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fredborg.org\/?p=440\"},\"wordCount\":713,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"image\":{\"@id\":\"https:\/\/fredborg.org\/?p=440#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png\",\"articleSection\":[\"Business Central\",\"Power Automate\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fredborg.org\/?p=440#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fredborg.org\/?p=440\",\"url\":\"https:\/\/fredborg.org\/?p=440\",\"name\":\"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint) - Fredborg\",\"isPartOf\":{\"@id\":\"https:\/\/fredborg.org\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fredborg.org\/?p=440#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fredborg.org\/?p=440#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png\",\"datePublished\":\"2020-12-08T06:26:37+00:00\",\"dateModified\":\"2020-12-23T20:43:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fredborg.org\/?p=440#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fredborg.org\/?p=440\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fredborg.org\/?p=440#primaryimage\",\"url\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png\",\"contentUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png\",\"width\":1536,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fredborg.org\/?p=440#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fredborg.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fredborg.org\/#website\",\"url\":\"https:\/\/fredborg.org\/\",\"name\":\"Fredborg\",\"description\":\"Business Central and Azure\",\"publisher\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fredborg.org\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\",\"name\":\"dfredborg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png\",\"contentUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png\",\"width\":256,\"height\":256,\"caption\":\"dfredborg\"},\"logo\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:fredborg.org\",\"https:\/\/www.linkedin.com\/in\/dfredborg\/\",\"https:\/\/x.com\/dfredborg\",\"https:\/\/www.youtube.com\/channel\/UCUNZglLDMjBlOK_T9JtI8UA\"],\"url\":\"https:\/\/fredborg.org\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint) - Fredborg","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:\/\/fredborg.org\/?p=440","og_locale":"en_US","og_type":"article","og_title":"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint) - Fredborg","og_description":"First&nbsp;off,&nbsp;I will start with a disclaimer, I am not a Power Automate guru, but I thought that it was about... Read more","og_url":"https:\/\/fredborg.org\/?p=440","og_site_name":"Fredborg","article_published_time":"2020-12-08T06:26:37+00:00","article_modified_time":"2020-12-23T20:43:50+00:00","og_image":[{"width":1536,"height":768,"url":"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png","type":"image\/png"}],"author":"dfredborg","twitter_card":"summary_large_image","twitter_creator":"@dfredborg","twitter_site":"@dfredborg","twitter_misc":{"Written by":"dfredborg","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fredborg.org\/?p=440#article","isPartOf":{"@id":"https:\/\/fredborg.org\/?p=440"},"author":{"name":"dfredborg","@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"headline":"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint)","datePublished":"2020-12-08T06:26:37+00:00","dateModified":"2020-12-23T20:43:50+00:00","mainEntityOfPage":{"@id":"https:\/\/fredborg.org\/?p=440"},"wordCount":713,"commentCount":0,"publisher":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"image":{"@id":"https:\/\/fredborg.org\/?p=440#primaryimage"},"thumbnailUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png","articleSection":["Business Central","Power Automate"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fredborg.org\/?p=440#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fredborg.org\/?p=440","url":"https:\/\/fredborg.org\/?p=440","name":"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint) - Fredborg","isPartOf":{"@id":"https:\/\/fredborg.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fredborg.org\/?p=440#primaryimage"},"image":{"@id":"https:\/\/fredborg.org\/?p=440#primaryimage"},"thumbnailUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png","datePublished":"2020-12-08T06:26:37+00:00","dateModified":"2020-12-23T20:43:50+00:00","breadcrumb":{"@id":"https:\/\/fredborg.org\/?p=440#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fredborg.org\/?p=440"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fredborg.org\/?p=440#primaryimage","url":"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png","contentUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2020\/12\/BCToSharePointPower.png","width":1536,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/fredborg.org\/?p=440#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fredborg.org\/"},{"@type":"ListItem","position":2,"name":"Let us talk PowerAutomate part 1 (Files from Business Central to SharePoint)"}]},{"@type":"WebSite","@id":"https:\/\/fredborg.org\/#website","url":"https:\/\/fredborg.org\/","name":"Fredborg","description":"Business Central and Azure","publisher":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fredborg.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d","name":"dfredborg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fredborg.org\/#\/schema\/person\/image\/","url":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png","contentUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png","width":256,"height":256,"caption":"dfredborg"},"logo":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/image\/"},"sameAs":["https:fredborg.org","https:\/\/www.linkedin.com\/in\/dfredborg\/","https:\/\/x.com\/dfredborg","https:\/\/www.youtube.com\/channel\/UCUNZglLDMjBlOK_T9JtI8UA"],"url":"https:\/\/fredborg.org\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=440"}],"version-history":[{"count":3,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/440\/revisions"}],"predecessor-version":[{"id":459,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/440\/revisions\/459"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/media\/458"}],"wp:attachment":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}