Unanswered

Get Items Returned Duplicates

(2) Share

Report

Posted on by JohnnySkye365

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...

Categories:

General topics

I have the same question (0)

All responses (22)

Answers (0)

CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey Mate @JohnnySkye365

You might want to use the Union() function to bring them both together and result in only the unique rows.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
JohnnySkye365 12 on at

Like (1)

Report
Copy link

Link copied!

Hey man,

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?

Thanks again....

JohnnySkye

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey Mate,

This is what I was trying to suggest - https://powerusers.microsoft.com/t5/General-Power-Automate/Remove-Duplicates-from-a-Sharepoint-List/td-p/427277

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
JohnnySkye365 12 on at

Like (0)

Report
Copy link

Link copied!

Ahh I understand now. The issue isn't duplicates in the list, it's that Get Items returned the same item twice.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@JohnnySkye365 Yep - Filter the "Get Items" after you get the items in Power Automate.

Was this reply helpful? Yes No
CFernandes 8,482 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@JohnnySkye365 Yep - Filter the "Get Items" after you get the items in Power Automate.

Was this reply helpful? Yes No
JohnnySkye365 12 on at

Like (0)

Report
Copy link

Link copied!

Sorry for the delayed response...

Surely the Get Items step shouldn't return the same item twice anyway? In this one run, it returned 2 items with the same InternalID.

Was this reply helpful? Yes No
JonBenito 26 on at

Like (0)

Report
Copy link

Link copied!

No solutions yet for this issue? Still experiencing duplicate internal ID till now. Thanks

Was this reply helpful? Yes No
JonBenito 26 on at

Like (0)

Report
Copy link

Link copied!

Think I found a solution, and it worked. Not sure which either of this, but I did (1) turn off Concurrency Control in apply to each and in (2) Get Items, just keep Order by parameter blank. No more dupes after the re-run.

Was this reply helpful? Yes No
panchomx 6 on at

Like (1)

Report
Copy link

Link copied!

Was this issue solved?
I'm currently facing same issue, whenever I execute the "Get Items" it's retreiving duplicates (for example rows with same SharePoint internal ID), it's not always having this behavior.

Regards,
Francisco

Was this reply helpful? Yes No