Hi @kungfupanda
Yes, it should be possible but not practical to create new list items in the same list.
Perhaps you meant to create new list items but in another list?
Why not Practical?
1. Data Structure Storage inefficiency - Ask your DB Admin or google 1NF, 2NF, 3NF
The light yellow cell are empty spaces.
2. Do you trigger a workflow to run when a new item is created in the list?
So when you add a new item, you will trigger a workflow to run. You may need to put in place additional conditions when you run a workflow. (Run when TITLE contains "Invoice")
What you need to do?
1. You need to Query the Repeating Data XML.
2. Extract each row, Process the row to extract the fields and save the value to the list (recommend to save to another list)
How to extract data from repeating section - Refer here https://community.nintex.com/t5/Nintex-for-Office-365-Forum/Query-XML-An-exception-occurred-while-processing-parameter/td-p/219094
Hi!
We want to keep all the information in the same list.
The idea is to allow users to do a submittal for 1 item or bulk submittal (the need for repeating section) as all fields could be different/unique.
Per invoice example below:
- Invoice 1 may contain 1 item
- Invoice 2 may contain 2 items
- Invoice 3 could be 1 item
- Invoice 4 could be 5 items
Embracing the Datasheet view would be better option?
Hi
Using the invoice example below:
- Invoice 1 may contain 1 item
- Invoice 2 may contain 2 items
- Invoice 3 could be 1 item
- Invoice 4 could be 5 items
Your SharePoint List has 4 items - Invoice 1-4.
Each Invoice form can have a Repeating Section to store the item(s) details.
Users can add or remove item(s) on the form
Sample Classic Form
Sample Responsive Form
Thank you for the reply.
We'll need to verify with the customer if they plan on entering more than 1 invoice per form or if it's acceptable to enter a single invoice number on each submittal.