Hi all,
I have created a table Employee in the sharepoint list which has fields
empid empname designation
when i have entered the one record in employee table
101 ram consultant
then one record has to be inserted in the department table automaticclayy
dep id deptname empid
1 IT 101
Can any one let me know whether this is possible in sharepoint list
Regards
Srini
Unless you are using Flow or a regular PowerApp app you can't have SharePoint populate a second list automatically when yiou create a new item in an existing list.
Hi @srinivas2212 ,
I've made a similar test and found the sharepoint custom form could only connect with itself list.
I'm afraid it's not supported to make this only by using sharepoint.
I suggest you use Flow or create an app connected with sharepoint list.
For example, create an app connected with sharepoint list:
Set the app connet with list1,list2
Set the form1's submit button's Onselect: SubmitForm(Form1);Patch(list2,Defaults(list2),{...,...,...})
Best regards,
Community Support Team _ Phoebe Liu
Yes its possible. Use two Data source connectors to access the two SharePoint lists. When you Submit the record for the first list add a Patch statement to the same action that adds a record to the second list. There is no way to create a relationship between the two lists that will add the record automatically, but your application can definately apply logic that will do it.