I a new to Power automate and jumping in with both feet because i need to get this flow going to archive items from a SharePoint list. I set up a simple test list and Excel workbook to run the flow off of. In advance, the key column/field we are keying on is the "Completed" column. The Excel spreadsheet has a 3 fields in this order - Title (text), Assigned (text), Completed (date, time not included). The intention of the flow is to trigger when when an item in the SharePoint list is created or modified (specifically when the Completed field is filled in with a date). The first action is for that record to be copied to the Excel spreadsheet for archiving,. The second action is for the that item to be deleted from the SharePoint list. This would leave only the active items in the SharePoint. We plan to run a reporting dashboard off the Excel spreadsheet for management so this can remove any manual moves and deletion of data. attached is the structure of my current flow. Again, I am an amateur at this point.
