Action "create_a_new_record" failed

(0) Share

Report

Posted on by Community Power Pla...

Hello, I am quite naive with flow so I apologize ahead of time. Please let me know if I need to post further details.

I have a flow that is to create a new case within our CRM when a "task" is added in Microsoft Planner.

I am getting the error:

')' or ',' expected at position 13 in '(Information Technology Solutions)'.

Here is the input and then the output for the "Create a new record" portion:

INPUT:

{
 "title": "TEST-PLANNER-NEWCASE",
 "casetypecode": 1,
 "prioritycode": 1,
 "_casetypecode_label": "Problem",
 "_customerid_value": "Information Technology Solutions",
 "_customerid_type": "accounts",
 "_caseorigincode_label": "",
 "_prioritycode_label": "Normal",
 "merged": false,
 "activitiescomplete": false,
 "blockedprofile": false,
 "_incidentstagecode_label": "Default Value",
 "checkemail": false,
 "customercontacted": false,
 "decremententitlementterm": true,
 "isdecrementing": false,
 "firstresponsesent": false,
 "_firstresponseslastatus_label": "In Progress",
 "followuptaskcreated": false,
 "isescalated": false,
 "adx_publishtoweb": false,
 "_messagetypecode_label": "",
 "_resolvebyslastatus_label": "In Progress",
 "routecase": true,
 "_customersatisfactioncode_label": "",
 "_contractservicelevelcode_label": "",
 "_servicestage_label": "",
 "_severitycode_label": "Default Value",
 "_statuscode_label": ""
}

OUTPUT:

{
 "status": 400,
 "message": "')' or ',' expected at position 13 in '(Information Technology Solutions)'.",
 "source": "itsolutionsco.crm.dynamics.com",
 "errors": [],
 "debugInfo": "clientRequestId: b43faae3-11a8-4afe-a284-14692df4f983"
}

Am I missing something simple here? Any assistance is greatly appreciated, I look forward to your reply.

Best,

Jreamz

All responses (6)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Action "create_a_new_record" failed

Hey all, I would like to note that I was able to get this resolved - The customer and owner just ended up needing a GUID, which I just put in statically. See screenshot below:

I appreciate everyone's input and assistance. Best wishes for the holidays!

Regards,

Jreamz
Community Power Pla... on at

Like (0)

Report

Re: Action "create_a_new_record" failed

After testing some other options, I've been thinking my filter query is incorrect. What are your thoughts?
Community Power Pla... on at

Like (0)

Report

Re: Action "create_a_new_record" failed

Yes it is related to the "Accounts" parent object, I believe. I'll go ahead and explore two parameters in that field and let you know how it goes! Thanks again.
MattWeston365 1,701 on at

Like (0)

Report

Re: Action "create_a_new_record" failed

Is the customer field a related field? I suspect that it wants an ID and a Value, so you might have to provide two parameters into that field.
Community Power Pla... on at

Like (0)

Report

Re: Action "create_a_new_record" failed

Hello @MattWeston365 I appreciate your timely reply!

Please, see requested screenshot:

Let me know if I need to show "advanced options".

Best,

Jreamz
MattWeston365 1,701 on at

Like (0)

Report

Re: Action "create_a_new_record" failed

Hi @Anonymous I haven't got a clue when it comes to CRM, but I'll see if I can help to spot the error in the automation. Can you please post a screenshot of the Create Record configuration? I suspect it's an issue with one of the pieces of information, but that will hopefully assist. If not I'll call in the cavalry!