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
GarryPope
Impactful Individual
Impactful Individual

Hello @BenDonahue,

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

Thanks,

Garry

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,367)