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

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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,966)