web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / To collect data into s...
Power Apps
Answered

To collect data into sharepoint list

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I want to add data to my table after searching. I use collect syntax but its  not work. Let me know if u have solution for my problem. 

 

Here the syntax :

Collect(EmployeeList2, {Code:Code.Text,Number: EmployeeNo.Text, 'Employee Name': EmployeeName.Text, Department:Department.Text, Shift:Shift.Text})

 

Thanks in advance!

Categories:
I have the same question (0)
  • Verified answer
    SebS Profile Picture
    4,797 Super User 2026 Season 1 on at

    @Anonymous 

     

    Try to use Patch instead :

     

     

    Patch(EmployeeList2, 
     Defaults(EmployeeList2), 
     {
     Code:Code.Text,
     Number: EmployeeNo.Text, 
     'Employee Name': EmployeeName.Text, 
     Department:Department.Text, 
     Shift:Shift.Text
     }
     )

     

     

    I'm not sure what you mean "after Searching" 

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @SebS 

     

    Thanks! It work as expected!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 493 Most Valuable Professional

#2
11manish Profile Picture

11manish 479

#3
Haque Profile Picture

Haque 328

Last 30 days Overall leaderboard