PowerAutomate Gift Lists to SharePoint - Avoid Duplicate Gifts

Mark Palfrey

Hi all

I am trying to setup a PowerAutomate which pulls gifts in from an RENXT Gift list into a SharePoint list. I wish this to refresh every day and I have got as far as adding gifts to the SP list however its duplicating them each time it runs. So I would like to somehow tell PowerAutomate to compare Gift IDs being pulled in against the SP list Gift IDs and only insert new rows into the SharePoint list where it doesn't match.

Any points on this would be great.

Mark

Matt Thacker

Hey @Mark Palfrey,

My thoughts would be to use the Get Items action for SharePoint and pull in all of the items that are currently in your list and append those Gift IDs to an array variable.

Then you can pull your gifts from NXT and add a conditional for each gift if the Gift ID is in the array, skip that gift; if it's not, add to the SharePoint list.

Heather McLean

@Mark Palfrey - did you get this working? Would you like to share at the User Group on Tuesday?

Mark Palfrey

Hey @Matt Thacker
Thank you so much for this. I think we have basically done what you sugguest now and it seems to be working in most part. However I have noticed that when we have a Split Gift the transactions do get duplicated in the SharePoint list even though its deduping based on Gift ID so something is forcing it through after the dedupe check is done. Any ideas on how to get around that one.

Mark Palfrey

@Heather McLean sorry for not getting back to you sooner. Have been totally swamped and somehow missed the notification. Our solution is still a work in progress and not full working as hoped yet. Have messaged Matt Thacker who kindly replied back to me on my original post.