sales@dynamicsedge.com
202-410-6400

We offer Custom Microsoft PowerApps Flow Stored Procedure Training Courses right here, right now, at Dynamics Edge, the official Microsoft partner you can trust.

Click this link right now in order to check out all the Microsoft PowerApps Flow Stored Procedure Training Courses offered by Dynamics Edge, the official Microsoft Partner you can trust.

Microsoft PowerApps Flow Stored Procedure Training SQL Dynamics Edge

Here is one reason you may need custom Microsoft PowerApps and Flow Training from Dynamics Edge. Let's suppose this scenario.
Let's say you need Microsoft PowerApps Flow Training because you had trouble passing parameters to Flow for executing a particular SQL server stored procedure. You may run into an issue with how Flow passes these parameters. You might think that this stored procedure takes in quite a few parameters (about 17 to twenty of them, all varchar value types of different sizes in this example). You might have tested the Stored Procedure a lot yourself outside of Flow with manual test case scenarios and have confirmed that it works correctly there. However, when looking at the issues generated you may notice that similar values which have been passed to Microsoft Flow are used distinctly in the different manual test case scenarios outside of Flow and even those work OK. The issues become obvious elsewhere. For instance you might get a Code 400 issue (otherwise known as a Bad Request) indicating that your SQL statements could be invalid. This might indicate that the parameter values are not being passed correctly but you're not sure yet.

Here's a rough pseudocode example of what you might have :

FlowName.Run(
If(varcharfilterAsOf,Text(dtpHomeAsOfDate.SelectedDate,ShortDate),Text(Today(),ShortDate)),
If(varcharfilterWorkerStatus,drpHomeWorkerStatus.Selected.Value,"~"),
If(varcharfilterWorkerType,drpHomeWorkerType.Selected.Value,"~"),
If(varcharfilterEmployeeType,drpHomeEmployeeType.Selected.Value,"~"),
If(varcharfilterContWorkerType,drpHomeContWorkerType.Selected.Value,"~"),
If(varcharfilterSOALevel && "0" in lstHomeSOALevel.SelectedItems.Value,"0","~"),
If(varcharfilterSOALevel && "1" in lstHomeSOALevel.SelectedItems.Value,"1","~"),
If(varcharfilterSOALevel && "2" in lstHomeSOALevel.SelectedItems.Value,"2","~"),
If(varcharfilterSOALevel && "3" in lstHomeSOALevel.SelectedItems.Value,"3","~"),
If(varcharfilterSOALevel && "4" in lstHomeSOALevel.SelectedItems.Value,"4","~"),
If(varcharfilterSOALevel && "5" in lstHomeSOALevel.SelectedItems.Value,"5","~"),
If(varcharfilterSOALevel && "6" in lstHomeSOALevel.SelectedItems.Value,"6","~"),
If(varcharfilterSOALevel && "7" in lstHomeSOALevel.SelectedItems.Value,"7","~"),
If(varcharfilterSOALevel && "8" in lstHomeSOALevel.SelectedItems.Value,"8","~"),
If(varcharfilterEmployeeEnum,textHomeEmployeeENum.Text,"~"),
If(varcharfilterSupervisorEnum,textHomeSupervisorENum.Text,"~"),
If(varcharfilterTermDtFrom,Text(dtpHomeTermDtFrom.SelectedDate,ShortDate),"~"),
If(varcharfilterTermDtTo,Text(dtpHomeTermDtTo.SelectedDate,ShortDate),"~"),
If(varcharfilterOrgSearchTerms,textHomeOrgSearchTerms.Text,"~"),
If(varcharfilterJobSearchTerms,textHomeJobSearchTerms.Text,"~"),
User().Email
)

Here's an example Stored Procedure execution call which may seem to be working for you:
EXEC [dbo].[SPNAME] '9/13/2018', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~', '~'
And an alternate version:
EXEC [dbo].[SPNAME] '9/13/2018', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''

However, you may still get the following error code text anyway:
{
"status": 400,
"message": "Microsoft SQL: Incorrect syntax near 'WHERE'.rn inner exception: Microsoft SQL: Incorrect syntax near 'WHERE'.rnclientRequestId: aaa-aa-aaaa-aaaa-aaaaaa",
"source": "sqlconnectionprovider-westus.tip0-westus.p.azurewebsites.net""
}

In this case, one issue could be the tested stored procedure you were using actually had one too many of the parameters to test when constructing your WHERE clause, so the issue was indeed in your original code. There could be one of many issues, If you ever need PowerApps Flow Stored Procedure custom Training, Support, Licensing, Consulting, anything related to Flow Stored Procedures help, or anything Power BI, PowerApps, Flow, Azure, SQL Stored Procedures, SQL Server and more - contact Dynamics Edge now - the official Microsoft partner you can trust!

202 S.E. Church Street, Suite 203 Leesburg, VA 20175
https://www.dynamicsedge.com/
sales@dynamicsedge.com
Solutions
Company
202 Church Street S.E. , Suite 203 Leesburg, VA 20175
202-410-6400
800-453-596 (Toll Free)
sales@dynamicsedge.com