Hi all,
I have a flow triggered by PVA, providing an ID (int).
I initialise 2 variables (var1, var2), both strings.
I connect to SQL Server (SQL Azure Database) - Execute Stored Procedure (V2) and run the procedure providing the ID above.
The procedure should return 2 values, both strings.
When I run the SP manually, it works fine and return what's expected.
BUT, when running from Power Automate, the output is somehow trimmed to be a single character.
I hope the attached images will demonstrate it properly.
Would appreciate any advice.
Thank you,
In SQL:
In Power Automate:
