web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Action "create_a_new_r...
Power Automate
Unanswered

Action "create_a_new_record" failed

(0) ShareShare
ReportReport
Posted on by

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.

 

imworstatflow.png

 

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

Categories:
I have the same question (0)
  • MattWeston365 Profile Picture
    1,701 on at

    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!

  • Community Power Platform Member Profile Picture
    on at

    Hello @MattWeston365 I appreciate your timely reply!

     

    Please, see requested screenshot:

     

    flow5.png

     

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

     

    Best,

     

    Jreamz

     

     

  • MattWeston365 Profile Picture
    1,701 on at

    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 Platform Member Profile Picture
    on at

    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.

  • Community Power Platform Member Profile Picture
    on at

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

     

    flow6.png

  • Verified answer
    Community Power Platform Member Profile Picture
    on at

    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:

     

    flowfinal.png

     

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

     

    Regards,

     

    Jreamz

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard