Best way to pass parameters (list) to Stored Procedure from Microsoft Flow

%3CLINGO-SUB%20id%3D%22lingo-sub-825677%22%20slang%3D%22en-US%22%3EBest%20way%20to%20pass%20parameters%20(list)%20to%20Stored%20Procedure%20from%20Microsoft%20Flow%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825677%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20been%20using%20the%20string_split%20function%20to%20get%20values%20from%20a%20comma%20separated%20parameter%20passed%20by%20Microsoft%20Flow%2C%20as%20discussed%20in%20the%20below%20video%2C%20but%20are%20wondering%20if%20anyone%20has%20found%20a%20more%20efficient%20way%20of%20passing%20parameters%20from%20Flow%20to%20SQL%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FBAGBzI4zdww%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FBAGBzI4zdww%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20all.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-825677%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBusiness%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hi everyone,

 

We have been using the string_split function to get values from a comma separated parameter passed by Microsoft Flow, as discussed in the below video, but are wondering if anyone has found a more efficient way of passing parameters from Flow to SQL?

https://youtu.be/BAGBzI4zdww

 

Thanks all.

0 Replies