Unanswered

Preventing SharePoint item duplication when using create item on Flow.

(0) Share

Report

Posted on by SlothKat

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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:

Best regards,

Alice

Was this reply helpful? Yes No
SlothKat 7 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No