I am a newbie to Power Apps and am working through creating an app that will allow work cells in a manufacturing environment to create requests for the materials warehouse to pick items they need for performing their part of the assembly process in completing assembly of a finished item.
I have a form created that has some "header" information like a unique request ID, the user creating the request, the finished item being worked on, etc.
There is then a gallery that displays applicable choices of material items based on the selected finished item. That gallery has a checkbox, the component item number, and an edit box to enter a quantity needed of the selected component item. Multiple items can be selected by checking the check box and entering a quantity needed.
Here is what I want to happen when all selections have been made for a request and the Submit button is clicked. I want to update 2 tables when submitting. I want to add records to a header table that has the type of information identified above. I then want to add records to a detail table that identify the items selected from the gallery as indicated by the fact that the associated check box is checked along with the quantity of that item required. I am having a tough time sorting out how I can pull the info on these selected items from the gallery and get that detail information into my intended data destination during form submit.
Can anyone point me in the right direction?
Thank you very much.
