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 / How to compare data - ...
Power Apps
Unanswered

How to compare data - update data or add new data to Table in teams

(0) ShareShare
ReportReport
Posted on by 2

I am using power app teams for development. 

I have a Power app Teams table in which monitoring data of machines are stored. It has around 2500 records 

 

Every day I receive new refresh data in excel where the structure of the columns and data types are same as of Power apps Teams Table. 

All I need to compare by machines serial , if row exist then update few columns only (Like current service Meter, current Location, Last Communication Date). And if not exist then add the new record.

 

Please guide me by advise, tutorial or video links, by which I can learn and solve the required situation, 

As this will be a big task of every day to compare so many records and update column, Also to compare and add new records

 

 

 

 

 

 

Categories:
  • RogierE Profile Picture
    879 Moderator on at

    I guess I would compare the Excel and the list with the help of PowerAutomate, especially because you want to have this comparison executed daily, whereas if you would use a PowerApp this comparison would only run if someone would open the App. For further tips please refer to the PowerAutomate section of this forum:

     

    https://powerusers.microsoft.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&filter=location&location=category:FL_Comm_Forums&q=compare%20excel%20and%20list

     

    Please like the reply and/or accept it as the solution if the answer is what you were looking for.

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

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 360 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 325

#3
Mohsin Ali Profile Picture

Mohsin Ali 232

Last 30 days Overall leaderboard