I am currently trying to create a Parts Ordering app. A simple app where technicians can select items out of our inventory catalog, input quantity, and submit to our inventory department.
My experience with PowerApps and Power Automate so far have been creating forms with a SharePoint custom list as the data source.
Currently I have columns setup in SPO for every field, technician answers questions on Powerapps, those fields get submitted then get populated into a DOCX template and emailed:
My problem is this. I have had to setup the fields all before hand, so say the technician actually needs 4 pieces of unique parts, but my SharePoint list and PowerApp only has space for 3 responses. They now have to submit two forms because thats the only work around I can think of without just adding 10 spaces for everything.
But if I overdo the number of spots available to fill out, then my Sharepoint list will have too many columns. (I already have 30+ columns)
This is the idea that I have that would work better for this situation:
So pretty much this is my idea. Just a "+" button that would add another line item to this form. The drop down would contain all of our part numbers. This seems better so that they can add as many items as they need.
So here's my question: What do I need to start researching to accomplish this? I am only familiar with using a excel table or a SPO Custom List for my data sources. How do I set this up to record the responses and send an email or document when completed?
If you want you can contact me at firstname.lastname@example.org and we can do a teams session and I can try to help you get a good plan.
In short I would setup a DUID "Data Use ID" that I created for each of my records no matter the table and link another table that would have the additions and still link back to the original order.