This is a pretty strange one that I've not been able to replicate.
My Flow is pretty big and does quite a lot. Essentially it gets items from a SharePoint list, does some calculations, creates items in another list, gets those items and creates a CSV file.
In Get Items step before creating the CSV I have a run that has returned 199 items, but there was only 197 items in the list. On checking the Outputs from the Get Items step I found 2 duplicate items (i.e. the same internal ID).
I have run the flow again and it didn't happen, but the fact that it has happened is causing some concern and I'm trying to find some kind of explanation as to why it happened.
Has anyone had anything similar or any suggestions as to why it might have occurred?
Thanks in advance...
Hey Mate @JohnnySkye365
You might want to use the Union() function to bring them both together and result in only the unique rows.
Thanks for getting back to me. I'm not sure I understand what you are proposing.
I only need to Output of 1 Get Items, to give me all the items in a list. It is within this Get Items step that the duplicate has been created, there's no duplicates in the list, the function has returned the same item twice.
Are you suggesting I should do something after the Get Items in case this happens again?
This is what I was trying to suggest - https://powerusers.microsoft.com/t5/General-Power-Automate/Remove-Duplicates-from-a-Sharepoint-List/...
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.