cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (10,477)