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...
@Dexrend Thanks so much for jumping in here with this input! Anxious to try this!
I had the Same issues. I couldn't get it to stop. if i compose the items in a Union function it got rid of them.
Facing this issue now. It is creating duplicates, triplicates, etc., when there is only 1 record. It is not consistent in the duplications. All the ID numbers are identical when it replicates a record so I know it is looking at only 1 record and should be returning only 1 record; not 2 or 3.
Seems as Get Items bug for me too. Removing orderby value is a workaround which fixed it for me.
Hi @panchomx good day! Are you able to share your expression used in Compose for "union()" so that we can see and pattern it to our side? Thanks!
I'm also getting the same issue with the outputs of the Get Items is returning duplicates for certain rows. Clearly appears to be a bug.
I also have this issue. I have 20 items in the list and it returns 40. Is anyone working on this issue?
I'm facing the exact same issue. There are no duplicates in the SharePoint list items but when I run the flow, in Get Items Output it clearly shows some duplicate items.
Can we write this to Microsoft?
I know it's been over a year since this was originally posted, but I had the same exact issue and was finally able to figure out what was happening. Again, the issue was that I was creating an HTML table with a filtered Get Items action, but the HTML table was only returning the first item in every single row. Weiiiiird right?
In case anyone else comes across this post and needs the solution:
In the Create HTML Table action, when you are selecting dynamic content for the Value column, make sure you are selecting the value from the "Get Items" section, NOT the "When an item is created or modified" section (or whatever your initial trigger was).
In the screenshots you can see that I searched for "link" in the dynamic content pop-up window and there are two values for "Link to item": one is in the Get Items section, and one is in the When an item is created or modified section. Again, pick the one in the Get Items section.
What I did to avoid duplicated records on Get Items is to add 2 additional steps:
1) Create an array variable using the Get Items output as the input
2) Use a compose using Union expresion
You can now use the compose output having unique records (avoiding duplicated SP internal IDs)
Hope this helps you!