Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Assistance needed passing parameter from powerapp button to flow to execute a stored proc

I have an inventory app that a user will look up parts first by part type, then once they select the part, they will see the inventory available from a sql database. once they see the available inventory they then reserve what they want form the warehouse they choose.

my data sources are the sql tables (parts, [part types]) , I have views for the availble inventory by partNo and warehouse.

on the detail page, I want to show the Quantity available from the sql view filtered by the selected partno

Here is how the app works (or not yet)

First I show the part types

part type.jpg


then the user selects the part they want


part detail.jpgNeed to filter the data table on the selected partno


Once they see the inventory, they can click the button to go to another screen to reserve the inventory.

On the next screen I plan to make a collection of their choice and write that to my transaction table in sql and update the inventory table with the reservation.


I have having an issue filtering the data table with only the selected partno


Super User
Super User

Re: Assistance needed passing parameter from powerapp button to flow to execute a stored proc

The question is likely better suited for the PowerApps community, because the functionality you are seeking lies more on the PowerApps side rather than the Flow side. With that said, I may be able to point you in the right direction.

PowerApps gives you the ability to filter directly from the CanvasApp based upon user and system-based filtering. For more information, please take a look at the official documentation for Filtering, Searching, and LookUp functions in PowerApps.

For some insight into the PowerApps filtering functionality, the following inventory app blog post, and this video about building a Lego brick inventory system may offer some insight. 

One key aspect of building PowerApps is to make sure that you are only relying on Flow for what can't be done within the PowerApp. This is important, because as the apps are updated and improved, the more things that are updated or tweaked in Flow, could break your PowerApp. For that reason, you want to redecude the Flow footprint in your PowerApp where you can.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Level: Powered On

Re: Assistance needed passing parameter from powerapp button to flow to execute a stored proc

I have determined how to filter my data, now i have my collection that i want to pass to my stored procedure via a Flow. I have the flow connected to the app, but cannot get my collection items to "run". The test in the flow is successful when run manually. this is my collection collection.jpgcollection dataFlow with parameters.jpgflow with parameter

I cannot get this data to pass into the parameters in the flow. Can anyone guide me to the correct process to use here?

Super User
Super User

Re: Assistance needed passing parameter from powerapp button to flow to execute a stored proc

Hi @kaybran 


What's the error message on the squiggly line? Can you please post it?



Fausto Capellan, Jr

Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!

Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020


Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Microsoft Learn

Learn how to build the business apps that you need


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 79 members 4,472 guests
Please welcome our newest community members: