Hi,
I've been working on this issue for multiple nights and I'm hoping someone in the community can help out.
My Flow
I created a custom connector that connects to my distributor to pull a price down on a daily basis --Works OK
Convert the Array to a Parse JSON --Works OK
Translate Parse JSON then ADD Row to existing Excel spreadsheet --Works OK
Now, when I take the same steps above and change Create Row to Update Rows in Excel it fails. The error that comes back is Row ID not found. I have tried to add an action before the apply to each to List Rows in the table and haven't solved the puzzle. My guess is that the Column ID and Trigger are not right in the Update Row section of the flow. Do I have to add the row ID into the Parse JSON? Also, don't think it matters, but the total rows are 1017 in the sheet. I changed some of columns in the first row to see if the update when I run the flow and nothing happens. Thanks.
Parse JSON
{
"type": "ParseJson",
"inputs": {
"content": "@body('Get_All_Products')",
"schema": {
"type": "object",
"properties": {
"ItemRequestResponse": {
"type": "object",
"properties": {
"Items": {
"type": "array",
"items": {
"type": "object",
"properties": {
"MFGPartNumber": {
"type": "string"
},
"Manufacturer": {
"type": "string"
},
"Description": {
"type": "string"
},
"MSRP": {
"type": "string"
},
"StandardUnitPrice": {
"type": "string"
},
"Price": {
"type": "string"
},
"Quantity": {
"type": "string"
}
},
"required": [
"MFGPartNumber",
"Manufacturer",
"Description",
"MSRP",
"StandardUnitPrice",
"Price",
"Quantity"
]
}
}
}
}
}
}
},
"runAfter": {
"Get_All_Products": [
"Succeeded"
]
}
}
Update ROW
