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

Report
All responses (
Answers (