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!
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 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.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.