Ok So far the research suggests that in order to pass input fields from Power Apps into a stored procedure one must first create a Power Automate flow. Here is what I have So far:
Power Automate:
I selected my stored procedure that requires 2 input values - Start Date and End Date. I selected the appropriate fields from the PowerApp Options for these two fields. I then created a Response which I am ASSUMING I will need this to then display the results on the Power App. (Not Sure how but I saw this from another post online)
Then hit save.
Next, I created a PowerApp, added two date picker fields, and a button. I then clicked on Action - PowerAutomate.
From there, I selected the Power Automate that I created in the first step.
As you can see from below Its now asking me to complete the Flow Parameters in the formula bars. I have NO IDEA what to create as the formula.
Lastly - I am now wondering what else is left to do in PowerApps in order to display a table with the results from the Stored Procedure directly in the PowerApp application.
Any help would be greatly appreciated.

Report
All responses (
Answers (