{"id":3900,"date":"2020-08-16T02:30:10","date_gmt":"2020-08-16T02:30:10","guid":{"rendered":"https:\/\/himbap.com\/blog\/?p=3900"},"modified":"2020-08-24T08:18:32","modified_gmt":"2020-08-24T08:18:32","slug":"getting-share-point-document-url-in-dynamics-365-ce","status":"publish","type":"post","link":"https:\/\/himbap.com\/blog\/?p=3900","title":{"rendered":"Getting Share Point Document URL in Dynamics 365 CE"},"content":{"rendered":"

Introduction<\/strong>
\nSometime we required to get full path of the image which we have uploaded to Share Point document for specific entity. In this article I am going to demonstrate how Microsoft Flow can be used to implement this requirement. Feel free to comment if there is another easy of doing this.
\n
\nThis article is assuming you have basic understanding of Dynamics 365 CE Share Point integration and Flow as well as Share Point integration is already configured.Keep in mind this is for the demo purpose but you can change it accordingly to your requirement.<\/strong><\/p>\n

Details<\/strong><\/p>\n

Let’s add a string field in the Contact entity where we are going to store URL, our field look like below
\n\"Imageurl\"<\/a><\/p>\n

Now Navigate to Flow and using Following steps:<\/p>\n

> Click on New and select automatic flow having following trigger<\/p>\n

\"Imageurl1\"<\/a><\/p>\n

> Let’s name our flow as “Set Image URL For Contact” and set action properties like below:
\n\"Imageurl3\"<\/a><\/p>\n

> Now let’s add some variable which we require for formatting URLs, Click on + New Step and search for variable and select Initialize Variable, In this variable we are going to set our Share Point Site URL.
\n\"Imageurl4\"<\/a><\/p>\n

> Add another integer type variable, where we are going to store last index of “\/” in URL, it should look like following:
\n\"Imageurl5\"<\/a><\/p>\n

In above express I am using following formula<\/p>\n

lastIndexOf(triggerBody()?[‘{Path}’],’\/’)<\/strong><\/p>\n

> Add another variable and call it Folder path, we will be setting this variable at later stage
\n\"Imageurl6\"<\/a><\/p>\n

> We need other variable to store image extension like following to validate specific file extension you can use based on your requirement.
\n\"Imageurl7\"<\/a><\/p>\n

We are using following formula in above variable<\/p>\n

last(split(triggerBody()?[‘{FilenameWithExtension}’], ‘.’))<\/strong><\/p>\n

> Add a condition and add condition to check folder and file extension like following
\n\"Imageurl8\"<\/a><\/p>\n

> Now under yes, blow first we are going to set folder path, this step may vary based on your entity name ,<\/p>\n

\"Imageurl9\"<\/a><\/p>\n

I am using following formula to set variable
\nsubstring(triggerBody()?[‘{Path}’],8,sub(variables(‘lastindex’),8))<\/strong><\/p>\n

Above 8 is count of entity +1 so for example cotnact\/ will be 8<\/p>\n

> Next we need to query document location record based on the folder path, we can use Dataflex (Common Data Service current) connector. Select List records and set it’s property like following<\/p>\n

\"Imageurl10\"<\/a><\/p>\n

In above we are going to query Document Locations record based on the Folder Path variable<\/p>\n

> Finally add a Update action from Dataflex (Common Data Service current) connector and set it’s properties like following<\/p>\n

\"Imageurl11\"<\/a><\/p>\n

Apply to each loop will be automatically applied when we will set field returned from Document Location record step. Finally our flow should look like below
\n\"Imageurl12\"<\/a><\/p>\n

Finally try to upload image to your entity you should see image URL populated after some time<\/p>\n

\"filename\"<\/a><\/p>\n

Summary<\/strong>
\nSo if you are need file name with extension or need path of the file you can use above Flow to store file name in CRM.<\/p>\n

Hope it will help someone!
\nKeep learning, Keep sharing !!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction Sometime we required to get full path of the image which we have uploaded to Share Point document for specific entity. In this article I am going to demonstrate how Microsoft Flow can be used to implement this requirement. Feel free to comment if there is another easy of doing this. This article is assuming you have basic understanding… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":3231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21,402,522,593,728,14],"tags":[798,805,801,799,800,803,802,804],"_links":{"self":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3900"}],"collection":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3900"}],"version-history":[{"count":7,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3900\/revisions"}],"predecessor-version":[{"id":3927,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/3900\/revisions\/3927"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=\/wp\/v2\/media\/3231"}],"wp:attachment":[{"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/himbap.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}