create one record in another table when one record is inserted in another table

(0) Share

Report

Posted on by srinivas2212

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

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.
srinivas2212 4 on at

Like
a
(0)

Report
Copy link

Link copied!

HI Pstork1, thanks for the reply.,you have told to build logic from front end but i need from sharepoint only just want to ellaborate on my requiremnt i am populating one list employee using import excel manually and it will create 4 records in employee list when 4 records are created in the employee list columns are (empid,empname,designation) i want to autopoulate another list department with same 4 empid and few other fields like created date and designation is it possible in sharepoint without using flow Regards srini
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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.