I have a store Procedure below which contains input parameter @customer_Test with varchar(8000).
ALTER PROCEDURE [dbo].[SPTestCustomer]
,@prod_group_id VARCHAR(8) = NULL
SET NOCOUNT ON
Now I successfully connected my database using On-Premise Gateway connector. And I am trying to execute my store Procedure through SQL Server "Execute stored procedure (V2)" action as shown below:
But my flow is failing and giving me error "The size (8000) given to the parameter '@Variable3' exceeds the maximum allowed (4000)."
This works well when I remove the input parameter with varchar(8000). Is there any limitation in MS Flow???
You may check the current limitations with the SQL connector here: https://docs.microsoft.com/en-us/connectors/sql/
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!