I have a Sharepoint list (with a Nintex workflow) which objective is to give a tracking to canceled orders from our products.
Each product is known as a ‘Style’, each Style can have multiple orders.
The reason they would cancel orders varies. Every time they canceled an order they will go to the SP and add it via an infopath form.
For example, there are 20 orders for Style 1 and all those orders were canceled and made into 1 order. Right know, the users would have to go and add 20 items (one for each canceled order) with practically the same information since the 20 orders were joined into 1.
I wish to simplify that, but for data integrity we cant allow the users to write 20 orders in one go, like “Order01, Order02… Order20” -> “NewOrder01”.
An idea I had was to have a another list, where the users will be able to write orders separated by a comma in a field. Then the flow will go through each order in that field and create as many items as there are in our main list, all with the same data except of course with a different canceled order.
Thing is, I am new to sharepoint and I dont know how to this. I can only use nintex.
