(Posted this question yesterday but it was marked as spam, sorry if the previous one is unlocked today and you see this question twice... I'm not stuttering!)
I am building a simple flow and want to use an inialiaze variable component. I created a SQL Server stored proc which use an integer as a parameter. Trying to use a initialize variable component in a Flow to assign a value:
So when testing the, I get prompted to enter a value:
But the test fails.
I guess to use the test interface there must be either a special syntax to use in the prompt value box or to use an integer variable in a flow, it must be bundle with other type of components in order to be recognize as integer. I have found these two discussions although I don't understand how to implement a compose action in my above flow:
What would be the point of allowing integer parameter, if they must transformed? Is it better to rewrite my stored proc and code the parameter as a string and do the conversion in transact-sql, which I'm more familiar with.