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
then the user selects the part they want
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
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!
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
I cannot get this data to pass into the parameters in the flow. Can anyone guide me to the correct process to use here?