cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SlothKat
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
v-yuazh-msft
Community Support
Community Support

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

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (71,066)