Flow is throwing duplicates to Excel file

[Pbargas]

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.

[wskinnermctc · Accepted solution]

Don't Get Items, that is unnecessary.

Your flow is currently saying "When a single item is modified" and that single item "Condition is Approved" then "Get All Items from SharePoint List" and for each item in the sharepoint list "Add a Row to Excel".

So there is no need to "Get Items" when you should just use the "When an Item is Modified" Trigger as the source data for adding a row into Excel.

[AWorley]

Hello, 
Personally I would take the new item itself and add it to the excel action "Add a row into a table". Power Automate works with excel tables, not with your usual excel rows/fields. So, convert your fields into a table and the table name will show (Default is Table1). 

After the Add a row into a table, you would purge the item from list by passing the Trigger's ID Field directly into the delete item action. This will remove the redundancy from your "Get Items", while fulfilling your requirements.

[Pbargas]

Much appreciated. I made the modifications as you stated and did a few tests runs and it seems to be working flawlessly.