Hi everyone,
I tried to create a new SalesQuotationHeader and SalesQuotationLines via Power Automate.
The Header works fine, but I can only create one line.
While the creation of the second line, this error occours:
An error has occurred. Write failed for table row of type 'SalesQuotationLineV2Entity'. Infolog: Warning: Line number 10.00 already exists; Warning: validateWrite failed on data source 'SalesQuotationLine (SalesQuotationLine)'.
The payload looks like this for the first and second line:
First Line - Works
{
"dataset": "xyz.sandbox.operations.eu.dynamics.com",
"table": "SalesQuotationLines",
"item/dataAreaId": "xyz",
"item/ItemNumber": "00015452",
"item/LineCreationSequenceNumber": 1,
"item/RequestedSalesQuantity": 1,
"item/SalesQuotationNumber": "1030057053"
}
Second Line - Doesnt work
{
"dataset": "xyz.sandbox.operations.eu.dynamics.com",
"table": "SalesQuotationLines",
"item/dataAreaId": "xyz",
"item/ItemNumber": "0002462012",
"item/LineCreationSequenceNumber": 2,
"item/RequestedSalesQuantity": 3,
"item/SalesQuotationNumber": "1030057053"
}
Any ideas how I can fix that?
