Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 11:00 AM (PST)
Microsoft Tech Community

Updating existing records and adding new records in table from Excel

Copper Contributor



I have a table that I'd like to update every day for the exiting records update, for the new records append.


I need this to be done from an excel spreadsheet. So, first filter CRM ID, then updates this CRM ID's tasks based on TaskID, and if new task, add it.


Googled and searched and tried something with Update, Delete, etc. queries but had no luck.


Any ideas or examples?


Thanks in advance,


0 Replies