Power Platform Community Forum Thread Details

Action 'add a row into a table' failed

I had created a pto request flow where a form is filled out, the response details are sent to someone to approve or not approve. If approved then the form responses are recorded in a new row of an Excel table in a Teams site. Things were going well until I had to transfer out of the department, at which time I transferred ownership of the flow to someone else. I was then removed from that department’s Teams site. The flow worked one time, but now getting the following error.

This is the raw input:
{
"method": "post",
"queries": {
"source": "groups/78ac87a0-429a-4a70-9d94-f82c8735868f"
},
"path": "/codeless/v1.2/drives/b%213juG7OyMZ0agdL2PWEdogc3x12pfBaBMhFfOMmvecO_TX0Wse-7MRZRiaNGqTiLJ/items/01ICEJ24JALJQWCFURRBFKLKW24UCZBP2K/workbook/tables/%7B32AA5D0B-B903-4943-9FD9-384627FD6EF4%7D/rows",
"host": {
"api": {
"runtimeUrl": "https://flow-apim-msmanaged-na-eastus-01.azure-apim.net/apim/excelonlinebusiness"
},
"connection": {
"name": "/providers/Microsoft.PowerApps/apis/shared_excelonlinebusiness/connections/shared-excelonlinebu-7452f828-b9e5-4deb-9113-057aebfd52de"
}
},
"authentication": {
"scheme": "Key",
"parameter": "*sanitized*",
"type": "Raw"
},
"body": {
"ID": "542",
"Submitted": "10/22/2024 5:19:10 PM",
"Email": "xxxx.xxxx@kp.org",
"Name": "xxxx",
"PTO Start Date": "2024-10-22",
"PTO End Date": "2024-10-22",
"Add any notes, if needed_x002e_": "",
"Approval": "Approve"
}
}

Categories:

Business Process Flows

Quick Links

Leaderboard > Power Automate