Using Power Automate in Power Apps

[NETGUY]

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.

[manuelstgomes · Accepted 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