Exec procedure with Table Parameter on Power Automate Desktop

(0) Share

Report

Posted on by humanstorm

Hey yall,

I need to find a way to execute a procedure with a table-valued parameter on Power Automate

I am pulling data from a CSV file into a data table variable but SQL profiler showing the data is passing through as if they are text.

EXEC dbp_proc_name_here S10811110221, 182148037, , TOM MACK, 2018-07-05, 14124d2040, LPDSA3AC9

I was able to archive this on UiPath showing this on SQL Profiler. Basically, they are creating an insert statement for each row into the temp table. Re-engineer this step on power automate might not be an ideal solution.

Now I know this isn't the best way but I am limited to this as direct access using bulk insert call is not an option at the moment.

declare @p1 dbo.test_test_test ##type table created prior

insert into @p1 values( values here )
insert into @p1 values( values here )
insert into @p1 values( values here )

exec dbp_proc_name_here _name=@p1

Does anyone have any advice or suggestion?

Categories:

Power Automate Desktop