How to get OData row ID

Dev 9 81

I am trying to get a Dataverse Row ID in a For each action:

The documentation
https://learn.microsoft.com/en-us/power-automate/dataverse/delete-row

does not specify HOW to get Row ID dynamically

User's image

By running, I can see that the OData Id value is HTTP_STUFF.dynamics.com/api/data/v9.1/ag_TABLE_NAME(ff042241-57c9-ed11-b597-000d3aaa0711)

So the actual Row ID string: ff042241-57c9-ed11-b597-000d3aaa0711 , is inside the paranthesis at the end of the URL. How do I get that string value?

By just using the ODataId value directly in a Get Row action, I get "message": "The response is not in a JSON format.",

MuthuKumaranMurugaachari-MSFT 22,311 Reputation points

2023-03-23T13:55:41.8333333+00:00

Dev 9 Please note that Power Automate is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

You may ask the experts in the dedicated Power Automate forum over here:
https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

1 answer

Dev 9 81 Reputation points

2023-03-23T10:52:26.41+00:00

I got the string by using first(split(last(split(items('For_each_2')?['@odata.id'], '(')), ')')), but is this really the way to go?
Please sign in to rate this answer.

2 people found this answer helpful.
Dev 9 81 Reputation points

2023-03-23T12:21:56.8566667+00:00

Actually, this also gives an "message": "The response is not in a JSON format.", error, so I don't understand the nature of this problem. Because passing a string for a known Row ID works.

Dev 9 81 Reputation points

2023-03-23T13:20:14.1433333+00:00

somehow it works now, perhaps it was some characters missing in copy-paste. Still, is this the way to extract the Row ID?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to get OData row ID

1 answer

Your answer