Power Platform Community Forum Thread Details

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?

Categories:

Building flows