Answered

Copy unique item from one list to other

(0) Share

Report

Posted on by Acyfka

Hi All,

Im part of IT SEC team in my organization. Every day I recive tons of mails, from contact center about phishing that our customers recive via phone text message.

I try to establish new system that could automate and filter my fight against phishing.

So here is quick idea about it

Contact Center give me URL/Domain using MS Forms -> I already made one Power Automate Flow to save answers as SharePoint List with uniqe IDs.

Next step is more complex and I need Your help. I need to copy uniqe URL/Domain from first list to other list.

All responses (2)

Answers (1)

v-alzhan-msft on at

Like (0)

Report

Re: Copy unique item from one list to other

Hi @Acyfka ,

I suggest that you should explain more details about the requirement, or share an example of the requirement so we could better understand you and provide the proper workaround.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Verified answer

Jcook 7,779 Most Valuable Professional on at

Like (0)

Report
Re: Copy unique item from one list to other

Hello @Acyfka

Is this something you're looking for?

SharePoint list with URL column

Initialize 2 array variables:

Next, I use Get items to get all items from that List, and use an Apply to each loop to loop through all items and append the URL value to the first array:

Now outside the loop, I use a Set variable with the second array. And use the expression union() to remove duplicates.

The expression syntax is:

union('<collection1>', '<collection1>')

Basically pass the same array twice into the union expression to return only unique values.

My expression looks like:

union(variables('URL'),variables('URL'))

Now a second apply to each can be used to iterate over the unique values, which can be stored / created into a new list: