Hello, I have a Power Automate flow that I am working on where it grabs the data from an inserted row from SharePoint list and loads into an on-prem SQL Server database. However, I am getting an error message:
Failed to update item '5'.
I think the issue is with the Row id but I am not sure what other option to choose for it as there is nothing in the dynamic content for it. I only see options from the SharePoint list.
Here is my CREATE TABLE statement I made for SQL Server to house this data:
CREATE TABLE [schema].[table](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [varchar](30) NOT NULL,
[email_address] [varchar](50) NOT NULL,
[created_date] [date] NOT NULL,
[transaction_type] [varchar](120) NULL,
[delivery_type] [varchar](120) NULL,
[work_order] [varchar](10) NULL,
[purchase_order_number] [varchar](20) NOT NULL,
[esimated_amount] [numeric](12, 2) NULL,
[category] [varchar](20) NULL,
[worktag] [varchar](100) NOT NULL,
[attachments] [varchar](250) NULL,
[description] [varchar](200) NULL,
[vendor_name] [varchar](20) NULL
)Am I supposed to be using a different ID for the dynamic content?

Report
All responses (
Answers (