An action in my flow which Updates a row in the dataverse is not working

[G0Springs]

From the research I found the example on the prior page which showed others solved the same error with the addition of an entity plural name in front of certain parameters. I attempted this with no luck.

Here I received the message:

{"error": { "code": "0x0", "message": "Resource not found for the segment 'msft_Project_ID'."}}

Another attempt I tried as to find the appropriate entity plural name was to look at the output of previous actions in the flow:

"@odata.type": "#Microsoft.Dynamics.CRM.msft_projectworkitem",

"@odata.id": "https://org0024a4f1.crm11.dynamics.com/api/data/v9.1/msft_projectworkitems(81fae7f8-4936-ec11-8c64-0...)",

"@odata.etag": "W/\"811017\"",

"@odata.editLink": "msft_projectworkitems(81fae7f8-4936-ec11-8c64-000d3a0ae287)",

From which I tried to just used msft_projectworkitems for all the parameters below is the list of different errors I received. 

When I tried again with /msft_projectworkitems(Dynamic content) I got the message:

{"error": {"code": "0x0", "message": "Bad Request - Error in query syntax."}}

I tried again with /msft_projectworkitems/(Dynamic content) I got the message:

{"error": {"code": "0x0", "message": "Empty segment encountered in request URL. Please make sure that a valid request URL is specified."}}

When I tried msft_projectworkitems(Dynamic content) I got the message:

{"error": {"code": "0x0", "message": "Bad Request - Error in query syntax."}}

If anyone could assist me in understanding these error messages and determine which what is the correct entity plural name to use for each parameter.

[v-bofeng-msft]

Hi @G0Springs :

If you not sure what the row id's name is,you could try this way to get it.

Best Regards,

Bof

[G0Springs]

@v-bofeng-msft I noticed that you circled the unique Data type. 

The rows which I am adding are of the Lookup data type, would this change how I tackle this problem.

Unfortunately it still is not working

I also tired adding a s after the Id in an attempt to make it plural but that did not work.

I tried /entityname(Lookup Field Value),   entityname/(Lookup Field Value) and    /entityname/(Lookup Field Value), but none of them worked.

[markcms]

This is supposed to be a low/no code system. I'm pulling my hair out at the same problem - It's easier to just run with a 'full code' system!

It's a lookup value, I'm giving it the ID. The relationship should define where to lookup. It shouldn't be anymore complicated than passing the ID. I just can't fathom why it isn't.

[Idesofmarch]

Did you ever resolve this matter?

[G0Springs]

Not to my recollection, I don't think I managed to crack it

[sagirkazi]

For Lookup columns, you need to pass the OData ID, per this article.

"When you want to create or modify a relationship, use standard OData notation. For example, while creating an account row, you should set the Primary contact column to the OData ID of a contact row like this: contacts(c96be312-4ac1-4358-99b6-1e14e2957b15)."

https://docs.microsoft.com/en-us/power-automate/dataverse/relationships

Hope this helps!

[jaeiow]

Thankful for a reply on an old thread, but how to retrieve the OData ID?

[Saylor]

I use the XRMToolkit (a free application you can download). You connect it to your database and can build the filter/query and select OData format. It will provide you with the correct formatting and information straight from what you input. 

[Vk4]

HI, the only thing which helped me is going again trough the whole flow. But check your names first of all, u probably use diferent column names which it expects. Try to chek //@odata.context there u can find your column names, for me the column was named diferently it was a name which never appeared before. If u are strugling to find where u can check the "odata.context" add a list rows step in your power automate and run a test, when it is done open the raw outputs in the {body} u will find names of the columns. 

Hope it helps