Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

How to create an order form where multiple items and their quantities can be added?

Posted on 26 Nov 2024 22:20:05 by
I am a noob and have been Googling and YouTubing for an answer and I kind of understand how to accomplish what I want but can't seem to get everything to work. So, I have an Engineering Order form where there are details like:
  • EO# - this should automatically be generated as it is sequential and I already setup the column to do this.
  • Date - this is just the Created column
  • Requestor - this is just the Created by column
  • Needed by - date picker
  • Location - text field
  • Shipping to - text field
Then is the order section. What I would like is a table that has 2 columns:
Product Name Quantity
   
 
But I want the user to be able to use a button/icon to add rows as needed. They should also be able to delete a row if needed. And then finally a button to submit the form. I have created two lists in SharePoint, one for the Orders and one for the Product Details. On the Orders list, I have a lookup column that points to the Product and Quantity columns of the Product Details list and on the Product Details list, I have a lookup column for the EO# column of the Orders list.
 
I'm not sure how to construct the form(s) so that the Product Name and Quantity fields are in a Gallery and then added to a collection so that when the form is submitted, everything works. I feel like I have a mess in the tree view and things are not nested the way they should for it work. Thank you in advance for any help you can offer.
  • ronaldwalcott Profile Picture
    ronaldwalcott 764 on 26 Nov 2024 at 23:43:50
    How to create an order form where multiple items and their quantities can be added?
    Why are you choosing this approach if you are new to Power Apps?
    Regarding your requirements, when you want to add a new order line you can popup a modal box (essentially entry fields in a container) enter the new order line, update the collection and refresh the display. A Delete button/icon would be on every line and just remove that row from the collection.
     
    You could also use this tutorial to see if it would satisfy your requirements and would probably be easier to modify
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,129

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,797

Leaderboard