cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Preventing SharePoint item duplication when using create item on Flow.

Hi all,

 

I've created a Flow to run on recurrence. It will get the group members of two disturbution lists. Then get the items of a sharepoint list. From there it will compare the email address, of the person pulled from the disturbution list, to the email address contained within the SharePoint list. If the address is on the list, it should do nothing. If the email address doesn't exist in the list. It should create a new item with the email address in it.

My problem, I'm having is that the flow keeps making duplicates of the people, from the disturbution lists. I would thought the condition would stop this from happening.

 

Any ideas?

 

Thanks,

Jon

Screenshot_1.pngScreenshot_2.png

 

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Preventing SharePoint item duplication when using create item on Flow.

Hi @SlothKat,

 

You should Apply to each member mail and each participantsEmail to see if the member mail is exists in the sharepoint list.

 

I would offer you a workaround to check from your first disturbution list to see if the member mail exists in the sharepoint list, and you could refer to my steps to create the following action to check from your second disturbution list to see if the member mail exists in the sharepoint list.

 

I have made a test on my side to create a participantsEmail column with Single line of text type in the sharepoint list.

Please refer to screenshot below to create the flow:

Capture.PNG

Capture.PNG

 

 

Best regards,

Alice

Highlighted
Frequent Visitor

Re: Preventing SharePoint item duplication when using create item on Flow.

Hi @v-yuazh-msft,

 

Thanks for your reply.

I tried your workaround you gave me but sadly the flow is still creating duplicates of the people on the list.

I've edited my Flow to match yours exactly. I did also try moving the second set variable to the first condition & then also remove it completely from the Flow. But the Flow would still duplicate people on the list.

 

Thanks,

Jon

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (10,861)