cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Salamander94
Helper IV
Helper IV

Adding fields to list as you go from app?

So I originally was going to have my data sit on an SP list.  However, the problem is this app will be for purchase orders.  Ideally, they don't want to fill out a seperate form for each individual item.  They want the ability to add extra items, but under the same title, if that makes sense. 

For example, the title of this Purchase Order will be PO 5.  I want to order ice cream and cake under PO 5, but unfortunetely there is only one field to choose an item and add its price, so I choose cake.  Now I have to create an entirely new form, PO 6,  in order to grab my ice cream. 

Is there no way to be able to add a field under a field per say?  So I can order my ice cream and my cake under PO 5?

2 REPLIES 2
LRVinNC
Resident Rockstar
Resident Rockstar

You need to use multiple lists in a parent/child relationship.  One list contains the PO information -- not the items.  The second list contains the Item information and also contains the PO Number so you can find all the items for a given PO.  Once the PO information is created you can take them to an items screen and allow them to enter multiple items.  When they complete all the items on that PO, they can return to a prior screen to create a new PO and start again.

LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Okay well unfortunetely, I'm having a super hard time figuring out how to do that.  Think you could provide me some details?  I've made two lists.  As for the child list I have an I.D. column from the parent list.  However, now what?  How would I view them together?

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,427)