How to copy SharePoint Online list items to another SharePoint list based on unique items
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:
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:
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:
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: