Hi,
I have a PowerAutomate with a trigger of "When a record is created" (in salesInvoices table) in Business Central and then, I want to get the details of this record. So, the second step is "Get record" from the salesInvoices table with Row id from the previous step.

When I test this PowerAutomate, "Get record" step gave me the below error:
{
"status": 400,
"message": "ErrorCode: Internal_ServerError You do not have the following permissions on TableData API Webhook Notification: Insert.\r\n\r\nTo view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '24223'. CorrelationId: 41626feb-809d-41e2-aaa0-e81ecc3b9ff2.\r\nclientRequestId: 281c87f4-d1e3-4c9f-9dc7-e267f6af2722",
"error": {
"message": "ErrorCode: Internal_ServerError You do not have the following permissions on TableData API Webhook Notification: Insert.\r\n\r\nTo view details about your permissions, see the Effective Permissions page. To report a problem, refer to the following server session ID: '24223'. CorrelationId: 41626feb-809d-41e2-aaa0-e81ecc3b9ff2."
},
"source": "api.businesscentral.dynamics.com",
"errors": []
}
It looks like I don't have permission to "Insert" data to this table (salesInvoices).
However, I have another PowerAutomate that is manually triggerred to "Get record" from the same table (salesInvoices) in the same Business Central environment. Here, I provided the "Row id" in the PowerAutomate. This runs successfully and data values from this record is retrieved.
Given the above, I suspect that something is not quite right with the connector.
Any idea?
dchan