Power Platform CommunityForums Power Automate - Building Flows Simple archival tool a...

Simple archival tool adding duplicates

(0) Share

Report

Posted on by CU17011400-0

My flow takes items from a Sharepoint list and adds them to an Excel file every 90 days, however it's adding duplicates. I'm trying to identify unique items with the unique Sharepoint ID. I believe it may be a value type mismatch, the Sharepoint ID value is listed in green whereas in Excel it's seen as a string and is in double quotes. However, changing the column in Excel to "Number" instead of Text hasn't worked. Any ideas? Thank you!

Categories:

Business Process Flows

All responses (1)

Answers (0)

Suggested answer

David_MA 8,929 on at

Like (0)

Report

Simple archival tool adding duplicates

I would first get the rows from your spreadsheet and find the ID value that is the greatest number. Then, when you use the SharePoint Get items action, use a filter query to where ID gt (greater than) the highest value from the spreadsheet. This way, you will only be getting items that were added since your last run.

If you encounter the issue with it treating the number as a string, just wrap the string value in an int expression and it will convert it to an integer. See this for more information: Convert String to Integer in Power Automate - SharePoint & Microsoft Power Platform Tutorials - SPGuides

If you are not familiar with how the ID field works in SharePoint, it is the primary key within every list and document library. The number starts at 1 and increments by 1 every time a new item is added. If an item is deleted, that ID is never used again.