I don't have anything quite as extensive as yours, but maybe this will help. The following is what is on the onSelect to run the flow. It builds a record with all the parameters and then sends it as JSON to the flow.
UpdateContext(
{
params: {
Customer: Concatenate(
txtCustomer.Text,
"%"
),
EndDate: Text(
dteEndDate.SelectedDate,
"[$-en-US]yyyy-mm-dd"
),
MaxValue: 50000,
MinValue: 40000,
StartDate: Text(
dteStartDate.SelectedDate,
"[$-en-US]yyyy-mm-dd"
)
}
}
);
ClearCollect(
returns,
StoredProcJSON.Run(
JSON(
params,
JSONFormat.IndentFour
)
)
)
And here is the flow. I Parse the parameter coming in and use those values in the stored procedure.
