Power Platform Community Forum Thread Details

Hello,

I running a power automate desktop flow. I'm trying to run the Execute SQL task (which I can do) against a SQL Server (version 2019) with a previous DataTable I grabbed from another task (in same flow) also from a SQL 2019 server. However, the stored procedure I'm trying to call has a table parameter. How (or can i) pass a DataTable in power automate to this TSQL procedure that has a TVP?

Example of procedure (on SQL 2019)

CREATE TABLE dbo.tbNames(
 ID int IDENTITY (0,1) NOT NULL 
 Name varchar(50) NOT NULL
)
GO
CREATE TYPE dbo.tNameEntry AS TABLE(
 Name varchar(50) NOT NULL
 PRIMARY KEY (Name)
)
GO
CREATE OR ALTER PROCEDURE dbo.InsertNames(
 @entries dbo.tNameEntry READONLY
)
AS
 INSERT INTO dbo.tbNames
 SELECT NAME FROM @entires
GO

I wanted to do in the Execute SQL command:
EXECUTE dbo.InsertNames %QueryResult%

This doesn't work. QueryResult is the result from a separate task in the same flow that was recieved from other SQL task against a SQL server 2019 database

Categories:

Power Automate Desktop