Home

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%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
Dawid van Heerden
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.

In this video Tutorial we look at how to query SQL tables from PowerApps and more specifically by using the infamous 'in' operator against an array! Unfortunately this is not support directly from PowerApps (yet), and SQL Queries are not supported (yet) to on-premises SQL servers so we have to use
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Teams error code - 6
damnit95 in Office 365 on
4 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies