Dynamics to Sharepoint Create Folder: Trouble with Document Location Creation

[Jenn_0014]

Hi All, 

I am creating a flow to create a folder in Sharepoint and a new Document Location in Dynamics dependant on a condition. 

My flow successfully creates the folder in Sharepoint but it doesn't create a new Document location to connect the account to the location on Dynamics. I am thinking it is something to do with the document location, I had this in text form but moved it to the ID number to see if it would make a difference but this still doesn't work. 

Thanks in advance

[abm]

Hi @Jenn_0014 

The image you posted is not very clear.

Are you setting the right Parent Site or Location GUID? Also Parent Site or Location Type as 'sharepointdocumentlocations'.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[Jenn_0014]

Sorry here is a better photo. I have the GUID in place but still, receive an error.

[abm]

Hi @Jenn_0014 

Thanks for your reply. What's the error you getting?

[Jenn_0014]

The error message that shows is ActionFailed. An action failed. No dependent actions succeeded.

the body error details: 

{

"status": 400,

"message": "')' or ',' expected at position 4 in '(257bCEDD3016-24E1-E911-A812-000D3A24F3F0)'.",

"source": "stepstirlingcrm.crm4.dynamics.com",

"errors": [],

"debugInfo": "clientRequestId: 315a053f-ff06-455a-8abf-7b96769413a9"

}

[Jenn_0014]

Hi all, anyone have a solution for this?

[abm]

Hi @Jenn_0014 

You need to map the parent site location using the dynamic property. Currently you have hardcoded '257bCEDD3016-24E1-E911-A812-000D3A24F3F0' this value. So try o get this by using a Get Record and map the id under Document location creation.

[Jenn_0014]

@abm Sorry can you advise how to:

Get Record and map the id under Document location creation. I have added a Get record action and put Document Location as the Entity but what do I put under Item identifier? I have tried adding the entity ID value 257bCEDD3016-24E1-E911-A812-000D3A24F3F0 but this receives an error. 

The parent location I wish to use isn't related to any Dynamics record, does this matter? 

[Jenn_0014]

@abm can you let me know what I should be inputting in the item identifier?

[abm]

Hi Jen,

I would say run an advanced find query in CRM to find the Parent Site record details from Document Location entity for account. You need to get the id in similar way in Flow to get the id by name (List record by name) probably Get Record by id is not the right one. If you need any further help please let me know.

[Jenn_0014]

HI @abm 

Sorry, I don't understand what you mean. 

To be clear. My flows purpose is to create a folder in SharePoint: this is done and then to link this folder to the dynamics account by creating a new document location and attaching it to the account. 

The problem I am having is creating te document location as I do not know how to relate it to its parent location which already exists but is not related to an account or other entity. 

So the item identifier and the Parent Site or Location int he below doesn't seem to work. 

[abm]

Hi @Jenn_0014 

Couple of things:

1. Remove the Get record.
2. Make sure Parent Site or Location Guid is 257bCEDD3016-24E1-E911-A812-000D3A24F3F0
3. Try removing the slash from Create a new record - Name property. Not sure slash is allowed in name or not.

Let me know how it goes.

Thanks

[Jenn_0014]

@abm no sorry this takes me back to having the error code as follows.

Status code
400
Headers
Pragma
no-cache
x-ms-request-id
29bc367b-f02c-4f58-8ae3-8bc6e21a0a27
Strict-Transport-Security
max-age=31536000; includeSubDomains
X-Content-Type-Options
nosniff
X-Frame-Options
DENY
Timing-Allow-Origin
*
x-ms-apihub-cached-response
true
Cache-Control
no-store, no-cache
Date
Mon, 18 Nov 2019 23:35:09 GMT
Set-Cookie
ARRAffinity=5946dfd0b4c9e5c85696630642a2bda2d4463dd138daf8b1584e53866d124773;Path=/;HttpOnly;Domain=dynamicscrmonline-ne.azconn-ne.p.azurewebsites.net
Content-Length
261
Content-Type
application/json
Expires
-1
Body
{
"status": 400,
"message": "')' or ',' expected at position 4 in '(257bCEDD3016-24E1-E911-A812-000D3A24F3F0)'.",
"source": "stepstirlingcrm.crm4.dynamics.com",
"errors": [],
"debugInfo": "clientRequestId: 29bc367b-f02c-4f58-8ae3-8bc6e21a0a27"
}

It's so frustrating! I really do appreciate your time helping me and hope we can find the resolution!

[abm]

Hi @Jenn_0014 

What screen share software you have? I am busy till 1.30 pm (UK Time) today.

Thanks

[Jenn_0014]

Would Google hangout work? Say 4pm today?

[abm · Accepted solution]

Hi @Jenn_0014 

I have constructed a flow similar like yours and it did worked as expected. Document folder created in SharePoint and I could access the document from D365 Account record.

Next I was trying to replicate your error by trail and error. Finally I managed to crack it down. What I did is I have used your GUID for the Parent Site or Location and got the below error.

{

"status": 400,

"message": "')' or ',' expected at position 4 in '(257bCEDD3016-24E1-E911-A812-000D3A24F3F0)'.",

"source": "spinhopedev.crm11.dynamics.com",

"errors": [],

"debugInfo": "clientRequestId: 4580535f-53ba-48f2-b5da-7274a0d92e6f"

}

 I was expecting a record identifier not found error, instead I got the above error 400. So what went wrong here.

The format of a valid GUID is a well-defined sequence of 32 hex digits grouped into chunks of 8-4-4-4-12.

So in your case GUID is as below:

257bCEDD3016-24E1-E911-A812-000D3A24F3F0

The grouped chunk format is 12-4-4-4-12.

When you trying to create document location it is expecting GUID 8-4-4-4-12 format. If you use the same format with an invalid GUID you will get invalid identifier error. 

In your case the length is more than the expected format so it is returning 400 which is really a confusing exception message 😞

So how to find the right GUID? Logon to CRM and run and advanced Query 

 

Next execute the results and open the record in a new window. Copy the URL in a notepad

https://xxxxxx.crm11.dynamics.com/main.aspx?pagetype=entityrecord&etc=9508&id=%7b58A939C4-250B-EA11-...

Above you can see id=%7b58A939C4-250B-EA11-A811-000D3A86AD99%7d

Remove the %7b and %7d. So in this case 58A939C4-250B-EA11-A811-000D3A86AD99 is my id.

Specify the right id in your flow step and it should work as expected.

Hope it is helpful and let me know whether you have resolved your issue or not.

If you need any further assistance please let me know.

[Jenn_0014]

Yes! Thank you! I can't believe after all that it was all down to an extra 7b!! Thank you so much for all your help!