Flow creates duplicate records in Sharepoint

[amahasheer]

Hello everyone,

I was trying to create a flow to automate creation of Sharepoint list items from flagging emails in outlook.

It worked well with me through the  below steps:

However, I noticed some duplication of records, therefore, I tried to manage this issue by fetching the email conversation ID in each share point item in order to use this field as a validation through standard condition as per below flow:

Unfortunately, this did solve my issue but make situation worst 😅 as I ended up with more duplications. 

Could anyone tell me what's did i do in this automation? and what is the best way to prevent such duplications?

Best regards, 

[v-litu-msft · Accepted solution]

Hi @amahasheer,

You should modify the Power Automate process, to let the logic like If the Issue ID does not exist in the SharePoint list, create an item, or update the corresponding item with the same issue ID. Now you could delete these duplicate items and follow steps as below:

1. Get items to find item with Issue ID equals to conversation ID;

IssueID eq '@{triggerOutputs()?['body/conversationId']}'​

2. Use length() function check if the return number of items equals to 0:

length(outputs('Get_items')?['body/value'])

3. If yes, create item, or update item

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[stefaniebuysse]

Hi,

I have the same problem. But  I can't find the solution.

I made a Microsoft forms with a flow to Microsoft list a couple of months ago. 

Since a month we receive our forms answers dubble in our Microsoft list.

Can anyone help me to fix it?

This is my selfmade flow with the help of youtube. It works very well but since a month we receive duplicates…