1. Trigger: The closest trigger is "When a row is added, modified or deleted" from the Excel Online (Business) connector, but it requires the Excel file to be stored in OneDrive or SharePoint and formatted as a Table. This trigger fires per row change, so you get only the updated row(s).
2. Excel Table Setup: Ensure your Excel data is formatted as a Table (not just a range). Store the Excel file in OneDrive for Business or SharePoint Online to use the trigger.
3. Flow Logic: Let's use the "When a row is added, modified or deleted" trigger. In the flow, get the changed row data from the trigger. Use this data to update your database table (e.g., SQL Server, Dataverse) for that specific row. This way, only the updated row is processed, not the entire dataset.
4. Database Update: Use the appropriate connector (SQL Server, Dataverse, etc.) to update the row based on a unique key (e.g., ID). Use an "Update row" or "Upsert" action to modify the existing record.
5. If your Excel file is not in OneDrive or SharePoint or not formatted as a Table: You cannot use the row-level trigger. You would need to schedule a flow (e.g., daily) that reads the entire table and compares rows with the database to detect changes, which is more complex and less efficient.
Note: Don't forget to consider error handliing mostly for database area if any update fails.
I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!
