Creating a SharePoint List which is a subset of an Existing SharePoint List

[SteveODea]

I have a large existing sharepoint list from which I wish to extract certain columns and create a new SharePoint list based on that data, but without repeating rows.

For example, I would like to turn this:

Person	Faculty	Course
Terry	Arts	Journalism
Jerry	Arts	Journalism
Sherry	Science	Physics

Into this

Faculty	Course
Arts	Journalism
Science	Physics

I had thought about creating an Array on the larger data set and then writing this array to a new SharePoint list, but I'm uncertain as to how I should avoid the duplicate rows in the array.

Here's what I have so far

Any help in eliminating the duplicate rows would be very welcome

Many thanks

[SteveODea · Accepted solution]

It's ok I found this post on topic which solves my problem

https://powerusers.microsoft.com/t5/General-Power-Automate/Array-variables-unique-values/td-p/266923

[Powerplatform01]

@SteveODea 

No worries , you can watch this video to resolve your issue.

https://youtu.be/OIIjOy-p-UE

Also request you to please subscribe this channel for further help.