Microsoft Dynamics 365 | Integration, Dataverse...

Power Automate flow failing because 'modified' Purchase Order doesn't exist

(4) Share

Report

Posted on by nksse

Hi all

I've got a flow that triggers when a purchase order is updated, and the trigger outputs the following example body:

{
  "Environment Name": "PRODUCTION",
  "Company Id": "a09476e9-c743-ed11-946f-xxxxxxxxxxx",
  "Row Id": "697c1e16-3a50-f011-be59-xxxxxxxxxxx"
}

The next step in the flow tries to retrieve this purchase order with this input:

{
  "bcenvironment": "PRODUCTION",
  "company": "a09476e9-c743-ed11-946f-xxxxxxxxxxx",
  "dataset": "v2.0",
  "table": "purchaseOrders",
  "id": "697c1e16-3a50-f011-be59-xxxxxxxxxxx"
}

And occasionally the flow fails with this error:

{
  "status": 404,
  "message": "ErrorCode: BadRequest_ResourceNotFound  Resource not found for the segment 'purchaseOrders'.  CorrelationId:  50c55ca3-6305-45e0-9e6a-xxxxxxxxxxx.\r\nclientRequestId: 528b3e24-eaec-4e0d-81a4-xxxxxxxxxxx",
  "error": {
    "message": "ErrorCode: BadRequest_ResourceNotFound  Resource not found for the segment 'purchaseOrders'.  CorrelationId:  50c55ca3-6305-45e0-9e6a-xxxxxxxxxxx."
  },
  "source": "api.businesscentral.dynamics.com",
  "errors": [
  ]
}

r/MicrosoftFlow - Strange Business Central behaviour

I don't understand how BC can indicate a modification to a record and fractions of a second later, the record doesn't exist. I've updated my logging to include ids when a PO is created, so that I can try follow what's happening.

But if anyone has any insights into what might be going on, it would be most appreciated.

Categories:

Power Platform integration

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Tom_Gioielli 2,319 Super User 2025 Season 2 on at

Like (1)

Report

Power Automate flow failing because 'modified' Purchase Order doesn't exist

I'm not as well versed in BC, but the "Resource Not Found" error in the CE world typically means that the table name is incorrect in your reference. Is it possible that the flow doesn't like the uppercase 'O' in purchaseOrders? The set name of the table (which is often a plural of the logical name) is usually in all lowercase.

I would check and confirm that the table set name is defined properly first, as it is what looks most likely to me to be causing the issue.

Was this reply helpful? Yes No
nksse 43 on at

Like (1)

Report
Power Automate flow failing because 'modified' Purchase Order doesn't exist

Hi @Tom Gioielli

I don't think that is the issue. The table is selected via dropdown. But in the flow trigger headers, the name is also listed with a capital O.

"parameters": { "bcenvironment": "PRODUCTION", "company": "@parameters('Business Central - Company Id - SSE (sse_BusinessCentralCompanyIdSSE)')", "dataset": "v2.0", "table": "purchaseOrders" }

Was this reply helpful? Yes No
Tom_Gioielli 2,319 Super User 2025 Season 2 on at

Like (1)

Report

Power Automate flow failing because 'modified' Purchase Order doesn't exist

Any chance your record GUID is incorrect, or some typo got in there somehow? It doesn't look like it from what I can see, but that error for me almost always means my reference is incorrect in some way.

You might also have some more luck posting this in the SMB forums section. Dynamics Community Forum Thread

Sorry I couldn't help more!

Was this reply helpful? Yes No
nksse 43 on at

Like (1)

Report

Power Automate flow failing because 'modified' Purchase Order doesn't exist

Thanks again @Tom_Gioielli. I'll try posting there too!

It's the id that Business Central gives to Power Automate as the modified record. Not something I store or alter at any point ¯\_(ツ)_/¯

Was this reply helpful? Yes No