Flow creates duplicate records in Sharepoint

(0) Share

Report

Posted on by 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,

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-litu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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…

Was this reply helpful? Yes No
elvinvaz 9 on at

Like (0)

Report
Copy link

Link copied!

I followed the steps but I am still receiving duplicates, why is this?

Was this reply helpful? Yes No