cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jackp514
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:

PowerApp

 

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:

Concept

 

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?

 

 

 

 

2 REPLIES 2
jackp514
Frequent Visitor

My pictures didn't load it looks like:

 

QhOoIxW

 

Flow:

0DnYXzg

 

Concept:

U6WRJEK

JayMagness
Solution Specialist
Solution Specialist

HI,

 

If you want you can contact me at jay@research-nest.com 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

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,405)