Showing results for 
Search instead for 
Did you mean: 
New Member

SharePoint Lists - order form add lines [One-To-Many]



I am trying to create a SharePoint list [can use powerapps to help] which allows me to place an order for items.


The issue is the One-to-Many relationship. I need to carry forward a unique ID e.g. persons name, and have the option to add additional items as normally people will raise multiple items in one go.


Is there a way to prevent them having to complete their information for every line of item they wish to order whilst carrying through their unique identifier?

Community Support
Community Support

Hi @mtparkes,


Could you please share a bit more about your scenario?


If you could provide more details about your scenario, we would provide a proper workaround for you.


Best regards,


Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-xida-msft,


Thanks for the reply,

Absolutely, let me see if i can provide some clarity.


I've been tasked to look at producing an online order form for personnel within the organisation to order items for personal issue. As a basic concept the form would need to include the type of information below as an example. So far I have a SharePoint List with the required fields and the Item Required field is linked to external an external database to pull through catalogue numbers etc for the Stores processing team.  Currently they will need to complete all fields and submit the entry for every single item they require.


Name  |  Personnel Number  |  Office  |  Item Required  |  Size  |  Quantity  |  Catalogue Number      etc....


The Problem:  When raising orders people will often want multiple items. At present I cannot understand how to enable them to create an order but add additional lines for the additional items. The output would need to populate a new row [not column] to enable picking/packing/delivery etc to take place   BUT critically will need to carry that individuals unique information [e.g. the first 3 collumns of info] else we cannot track the order location/person.


I've been looking at using powerapps for customised forms and the  OnSubmit     'ForAll(Patch...'   function    but cannot get this to work.


What I am seeking to do is carry the unique info into multiple orders without them having to fill that info in twice or populate an additional form...which i believe is this One-to-Many relationship issue.   The areas of sticking currently are: 1] the ability to add multiple lines to one record  and   2] ability to join the unique identifiers to a new order line without duplication of that info



I hope this makes a bit more sense?


Thank you,

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (37,067)