Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual

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:




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.


Hello @BenDonahue,

Thanks for the reply.

If you type Common into the search box you'll see two connectors called Common Data Service, but one will be Common Data Servi... this is the one you want, as it's the Common Data Service (current environment). It's confusing, I know. But the Common Data Service is the older connector and the Common Data Servi... is the newer connector. See screenshot below. 


CDS CE.png Thanks,


Impactful Individual
Impactful Individual

Unfortunately, that does not happen on my end:


 And with "list records:"


Switching to Premium filter:


This is all very curious. I am beginning to think that this is less of a "Ben" issue than it is a "Microsoft" issue.

What are you thoughts? Open a ticket?

Hello @BenDonahue,

Thanks for the screenshots, yes, that's odd. I've never seen that before.

Raise a ticket and see what Microsoft say. 




Impactful Individual
Impactful Individual

I did yesterday and will have an a talk with a support rep later today.


This is how it seems to go with me; what is supposed to be the hard part, specifically working with new concepts and creatively and securely implementing them, like grabbing code generated from Advanced Search and placing it in a uniquely functional block, abstracting it to be usable in a dynamic sense, ends up being the easy part, while finding the block to click is the hard part requiring, 4 professionals to solve, IF it gets solved by the first support rep.


I want to thank you again for all your help. You have, I believe, given me the tool I need to address this, and many future, problems, and will be certain to award you with the solution when it works.


Presumably, when I am able to click the block, I'll reference the instructions you posted along with the information in the link, get the thing to work, award the solution and move on to the next challenge. Meh, I'm feeling lucky today, so we should be good. 🙂

Impactful Individual
Impactful Individual

@GarryPope  ,

After rambling on below, I finally have the question I believe I need answered; let me provide it here, so you don't have to read all that:

What is the value I want to have on the Customer line, please? It is a complex value, being the record for the user.


If you're still with me, please know that I can't thank you enough for all the help you have already provided, much less any you might yet provide.


Good news,/Bad News


The Good News:


My problem is that I was trying to create a Flow from within My Flows. For some reason, this is bad, as Common Data Service (current environment) is not available to Flows created from within My Flows, but only to Flows created from with a Solution. So, I created a solution and created the Flow there. That got me moving right along. One "Gotcha" moment came in copying and pasting the fetch code from Advanced Search; I had to remove the dashes from in front of the parent lines. That done, the block worked perfectly; I created the List Rows block and added the Fetch XML code copied from Advanced Search, replacing the email address with the dynamic content Responder's Email.



moving right along, that is, until...


The Bad News: 


Create a row happened. That is proving troublesome. it doesn't seem to like the values I am supplying for much of anything, but let's start with Customer. I'm using this in the block: 



Where User is the GUID. I get, another other information, this error message: 


 "message": "Creating Entity with an invalid parent. Entity: Incident, ReferencingAttribute:customerid"


Prepending a slash to sustemusers, gets me this error message:


  "@Microsoft.PowerApps.CDS.InnerError.Message": "Creating Entity with an invalid parent. Entity: Incident, ReferencingAttribute:customerid"


What is the value I want to have on the Customer line please?

Hello @BenDonahue,

Mate, I can't believe I missed that with the Common Data Service (current environment). I always create my Flows in solutions, hence why I missed it. Sorry.


Okay. So your question...

I don't believe you'll be able to populate the Customer (Contacts) column with the values from the User table.   

Here is the Microsoft Docs on the data type Customer column.


In the Customer (Contacts) field you'll want to pass the GUID of the Contact not the User.

If I remember rightly, when the person completes the Microsoft Forms form you get their email address. And all those people are Contacts in your Dataverse environment.

So if you just do the same as we did for Users, but use Contact instead, you'll then be able to get GUID column for the Contact, which is contactid then pass that into the Customer (Contacts) column on your Case.


I haven't tested this though. It's a bit difficult to explain, but I hope that makes sense?



Impactful Individual
Impactful Individual

I don't believe there is any documentation stating the connectors available in Solutions are not available in My Flow. Best Practices, it would seem, is never to use My Flows.

I posted my next new, fun and interesting issue, and tagged you in it.

Honestly, at this point, I actually hope it is me this time, like, missing a comma, environment mis-match, something that speaks to the stability of this platform, and makes me a better developer.

I can't believe I'm the first person to ever want to make a form to create a row in Case, but it might just be so. Now, at least, there will be a roadmap for anyone following me, with your name and help integral in it's creation.

(Grats Continued Contributor, btw) 

And with that last piece of the puzzle you helped with on the other question, I am over the finish line. You have been very generous with your time and help. I look forward to the opportunity to give you assistance with a problem eventually, however unlikely that may be.

If you want to copy that solution over to here, to finish out this question, I'll award it the solution.

You're the best, @GarryPope!

Hello @BenDonahue,

Happy to help. Just ask if you have any other questions in the future. 

Have a good one!



Do you want to copy your solution to the other stand alone question over to this thread as it wraps up the whole thing?

Helpful resources


Power Platform Connections - Episode 7 | March 30, 2023

Episode Seven of Power Platform Connections sees David Warner and Hugo Bernier talk to Microsoft MVP Dian Taylor, alongside the latest news, product reviews, and community blogs.     Use the hashtag #PowerPlatformConnects on social media for a chance to have your work featured on the show!      Show schedule in this episode:    0:00 Cold Open 00:30 Show Intro 01:02 Dian Taylor Interview 18:03 Blogs & Articles 26:55 Outro & Bloopers    Check out the blogs and articles featured in this week’s episode: @crmbizcoach​/  @pranavkhuranauk @MMe2K​ @StefanS365 @D365Goddess @MMe2K    Action requested:  Feel free to provide feedback on how we can make our community more inclusive and diverse.    This episode premiered live on our YouTube at 12pm PST on Thursday 30th March 2023.    Video series available at Power Platform Community YouTube channel.    Upcoming events:  Business Applications Launch – April 4th – Free and Virtual! M365 Conference - May 1-5th - Las Vegas Power Apps Developers Summit – May 19-20th - London European Power Platform conference – Jun. 20-22nd - Dublin Microsoft Power Platform Conference – Oct. 3-5th - Las Vegas    Join our Communities:  Power Apps Community Power Automate Community Power Virtual Agents Community Power Pages Community    If you’d like to hear from a specific community member in an upcoming recording and/or have specific questions for the Power Platform Connections team, please let us know. We will do our best to address all your requests or questions.       

Announcing | Super Users - 2023 Season 1

Super Users – 2023 Season 1    We are excited to kick off the Power Users Super User Program for 2023 - Season 1.  The Power Platform Super Users have done an amazing job in keeping the Power Platform communities helpful, accurate and responsive. We would like to send these amazing folks a big THANK YOU for their efforts.      Super User Season 1 | Contributions July 1, 2022 – December 31, 2022  Super User Season 2 | Contributions January 1, 2023 – June 30, 2023    Curious what a Super User is? Super Users are especially active community members who are eager to help others with their community questions. There are 2 Super User seasons in a year, and we monitor the community for new potential Super Users at the end of each season. Super Users are recognized in the community with both a rank name and icon next to their username, and a seasonal badge on their profile.  Power Apps  Power Automate  Power Virtual Agents  Power Pages  Pstork1*  Pstork1*  Pstork1*  OliverRodrigues  BCBuizer  Expiscornovus*  Expiscornovus*  ragavanrajan  AhmedSalih  grantjenkins  renatoromao    Mira_Ghaly*  Mira_Ghaly*      Sundeep_Malik*  Sundeep_Malik*      SudeepGhatakNZ*  SudeepGhatakNZ*      StretchFredrik*  StretchFredrik*      365-Assist*  365-Assist*      cha_cha  ekarim2020      timl  Hardesh15      iAm_ManCat  annajhaveri      SebS  Rhiassuring      LaurensM  abm      TheRobRush  Ankesh_49      WiZey  lbendlin      Nogueira1306  Kaif_Siddique      victorcp  RobElliott      dpoggemann  srduval      SBax  CFernandes      Roverandom  schwibach      Akser  CraigStewart      PowerRanger  MichaelAnnis      subsguts  David_MA      EricRegnier  edgonzales      zmansuri  GeorgiosG      ChrisPiasecki  ryule      AmDev  fchopo      phipps0218  tom_riha      theapurva  takolota     Akash17  momlo     BCLS776  Shuvam-rpa     rampprakash  ScottShearer     Rusk  ChristianAbata     cchannon  Koen5     a33ik  Heartholme     AaronKnox  okeks      Matren   David_MA     Alex_10        Jeff_Thorpe        poweractivate        Ramole        DianaBirkelbach        DavidZoon        AJ_Z        PriyankaGeethik        BrianS        StalinPonnusamy        HamidBee        CNT        Anonymous_Hippo        Anchov        KeithAtherton        alaabitar        Tolu_Victor        KRider        sperry1625        IPC_ahaas      zuurg    rubin_boer   cwebb365   Dorrinda   G1124   Gabibalaban   Manan-Malhotra   jcfDaniel   WarrenBelz   Waegemma   drrickryp   GuidoPreite    If an * is at the end of a user's name this means they are a Multi Super User, in more than one community. Please note this is not the final list, as we are pending a few acceptances.  Once they are received the list will be updated. 

Register now for the Business Applications Launch Event | Tuesday, April 4, 2023

Join us for an in-depth look into the latest updates across Microsoft Dynamics 365 and Microsoft Power Platform that are helping businesses overcome their biggest challenges today.   Find out about new features, capabilities, and best practices for connecting data to deliver exceptional customer experiences, collaborating, and creating using AI-powered capabilities, driving productivity with automation—and building towards future growth with today’s leading technology.   Microsoft leaders and experts will guide you through the full 2023 release wave 1 and how these advancements will help you: Expand visibility, reduce time, and enhance creativity in your departments and teams with unified, AI-powered capabilities.Empower your employees to focus on revenue-generating tasks while automating repetitive tasks.Connect people, data, and processes across your organization with modern collaboration tools.Innovate without limits using the latest in low-code development, including new GPT-powered capabilities.    Click Here to Register Today!    

Check out the new Power Platform Communities Front Door Experience!

We are excited to share the ‘Power Platform Communities Front Door’ experience with you!   Front Door brings together content from all the Power Platform communities into a single place for our community members, customers and low-code, no-code enthusiasts to learn, share and engage with peers, advocates, community program managers and our product team members. There are a host of features and new capabilities now available on Power Platform Communities Front Door to make content more discoverable for all power product community users which includes ForumsUser GroupsEventsCommunity highlightsCommunity by numbersLinks to all communities Users can see top discussions from across all the Power Platform communities and easily navigate to the latest or trending posts for further interaction. Additionally, they can filter to individual products as well.   Users can filter and browse the user group events from all power platform products with feature parity to existing community user group experience and added filtering capabilities.     Users can now explore user groups on the Power Platform Front Door landing page with capability to view all products in Power Platform.      Explore Power Platform Communities Front Door today. Visit Power Platform Community Front door to easily navigate to the different product communities, view a roll up of user groups, events and forums.

Microsoft Power Platform Conference | Registration Open | Oct. 3-5 2023

We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! But first, let's take a look back at some fun moments and the best community in tech from MPPC 2022 in Orlando, Florida.   Featuring guest speakers such as Charles Lamanna, Heather Cook, Julie Strauss, Nirav Shah, Ryan Cunningham, Sangya Singh, Stephen Siciliano, Hugo Bernier and many more.   Register today:   

Top Solution Authors
Top Kudoed Authors
Users online (1,918)