Power Platform Community Forum Thread Details

I'm trying to connect a flow with a Stored Procedure of SQL Server using Linked Server to DB2/400.

But, I've a problem:

When, in SQL sentence, I put fixed condition get a good answer of the flow, like:

Where ORDER='12345'

But, when I put a variable condition the answer is blank,

Where ORDER=''''' + @order + '''''

In SQL Server, sentence SQL works fine with Linked Server.
Could you tell me how can I solved this issue?

Thanks
Daniel

Categories:

Connect flow with Store Procedure using Linked Server to DB2/400