cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenDonahue
Skilled Sharer
Skilled Sharer

Create a case in D365 using either Dynamics or Common Data Service connector in Power Automate

 

 

Attempting to create a new case in out Dynamics 365 Sandbox, I have tried to use the template, "Create a new record in Dynamics 365 on Microsoft Forms submission." In the block, "Create a new record" that is using a Dynamics integration, I get the error, "

Bad Request - Error in query syntax." 
 
Here is my block:
 
 

 

d365CaseCreationFail1of2.png
d365CaseCreationFail2of2.png

 

My first instinct is that the Owner is of data type, "Owner" which is a record. If this is the issue, how can I access the user's record? I tried Get Record and using the body of that, but to no avail.

Thank you for your help in this; it is greatly appreciated.

21 REPLIES 21

Hello @BenDonahue,

As requested, here's the URL to your other post where I answered this question. 

Thanks,

Garry

BenDonahue
Skilled Sharer
Skilled Sharer

There were lots of pieces to the ultimate solution you provided. Now should a second person want to do this, there is a detailed roadmap. I still can't believe that I'm the very first one, maybe just the first one to not know how to do it and needed to research it.

It was a long road, and you finally pushed me over the finish line, and I very much appreciate it, thank you 

@GarryPope .

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (1,581)