Answered

Flow is throwing duplicates to Excel file

(0) Share

Report

Posted on by 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.

Categories:

General topics

Duplicating Flow....

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
AWorley 414 Super User 2024 Season 1 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Pbargas 5 on at

Like (0)

Report

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

Was this reply helpful? Yes No