Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 4

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:
  • Pstork1 Profile Picture
    Pstork1 64,822 on at
    Re: create one record in another table when one record is inserted in another table

    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.

  • Re: create one record in another table when one record is inserted in another table

    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

  • srinivas2212 Profile Picture
    srinivas2212 4 on at
    Re: create one record in another table when one record is inserted in another table
    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
  • Pstork1 Profile Picture
    Pstork1 64,822 on at
    Re: create one record in another table when one record is inserted in another table

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard