cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arindam40
Helper I
Helper I

How to copy SharePoint Online list items to another SharePoint list based on unique items

Hi Team,

I am trying to copy SharePoint Online list items to another SharePoint list based on unique items.

This original list is saving Microsoft message center major service update items in a list & looks like this:

arindam40_0-1646773641924.png

These data are fetched from Graph API & saved in this SharePoint list. But these messages have lot of update messages & hence there are lots & lots of duplicates. I am trying to copy all items from this original list to another SharePoint list, based on Unique value items.

I am trying to build a flow but got stuck here:

arindam40_1-1646773787526.png

From the list, I am trying to target the Title items, which are the message numbers & trying to find the unique items from the Array, using union() method, passing selected data:

arindam40_2-1646773965445.png

After saving here, when I run it, I could see data collected.

I also tried removing other items, & select only Title column data to compare, like this

If I do this, it gives same issue, not able to satisfy the logic to create an item:

 

arindam40_3-1646774398870.png

arindam40_1-1646773787526.png

Where exactly am I going wrond? How to fix this?

Any help will be great.

 

Thanks

Arindam

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,481)