Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Creating Custom Form without Sharepoint List

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?





Frequent Visitor

My pictures didn't load it looks like:









Solution Specialist
Solution Specialist



If you want you can contact me at 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.

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,374)