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.
Solved! Go to Solution.
Hi @NETGUY
To pass information from Power Apps to Power Automate, you can use the Run as you're using and then comma-separated parameters. They will be picked up by Power Automate, and then Power Automate will process the information. Something like this:
'Name of the Power Automate'.Run(parameter1, parameter2);
Is this what you're looking for?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
Hi @NETGUY
To pass information from Power Apps to Power Automate, you can use the Run as you're using and then comma-separated parameters. They will be picked up by Power Automate, and then Power Automate will process the information. Something like this:
'Name of the Power Automate'.Run(parameter1, parameter2);
Is this what you're looking for?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel