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 / Bulk update from two t...
Power Apps
Unanswered

Bulk update from two tables related

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

 

I have 2 tables
Table 1: Customer_Id, Customer_Name
Table 2: Customer_Name, date_Contract, Customer_Id
I need to update the Customer_Id field of the whole table 2 by crossing the Customer_Name of both tables.

The tables are in Sharepoint Lists and have more than 2000 matches.

 

Thanks for your Help

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Please provide more information.

    1. What's the data type of Customer_Id column?
    2. What's the data type of Customer_Name column?
    3. Do you want to use table1 to filter the records of table2 first?
    4. After you update the values of the Customer_Id column of table2, do you want to update the value of the Customer_Id column in table1?
    5. What control do you use to update the value?
    6. Do you mean that when table1 selects a Customer_Id, there are more than 2000 related records in table2?

     

    Best Regards,
    Wearsky

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks,

     

    1. Custumer_Id is text type.

    2. Customer_Name is Text Type.

    3. I need fill the table 2 with the Customer_Id from table 1, match the field  Customer_name from the table1 and table2.

    4. Nop, i need update de Customer_Id in to the table 2 only why i have the Customer_Id in the table 1.

    5. Not undertand the question.

    6. My question was tinking about the delegate problem for some functions.

     

    Tanks so much for your help.

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 305 Most Valuable Professional

#2
11manish Profile Picture

11manish 212

#3
Valantis Profile Picture

Valantis 167

Last 30 days Overall leaderboard