cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Responsive Resident
Responsive Resident

Need help with creating a single column with uniques values from 3 columns from the same SharePoint list

Hello all, 

 

I am trying to learn data operations in Power Automate, but got stuck with the task to create a single column with unique values from columns from the same SharePoint list. 

 

This is my Sharepoint list structure in its simplest form:

 

id | team_member 1 | team_member 2 | team_member 3 |
1  |   A           |   B           |       C       |
2  |   D           |   A           |       B       |

 

 
This is my Sharepoint list "to be" structure:

 

id | team_members |
1  |   A          |      
2  |   D          |    
1  |   B          |
1  |   C          |
2  |   A          |
2  |   B          |

 



Is it possible to achieve such objective with Power Automate? Would sincerely appreciate an advice since I don't know where to start..

1 ACCEPTED SOLUTION

Accepted Solutions
Responsive Resident
Responsive Resident

Managed to find solution using multiple conditions to check different values of columns.

 

This video has helped to find a solution how to recognize whether the item was updated or created as new: https://www.youtube.com/watch?v=yLBohC1Rw00&t=192s&ab_channel=AlirezaAliabadi

View solution in original post

3 REPLIES 3
Super User
Super User

Hi @mantastg08876 

Will the formatting for your source always be constant / never-changing? Are these headers and the spacing ever going to change? This data is coming from an SP list right?

id | team_member 1 | team_member 2 | team_member 3 |

As long the spacing and your template won't change I could most likely give you a solution.

Hi @Amanthaper ,

Thank you for your response!

 

The spacing and the template won't change, and the data source would be an SP list.. Have you done similar data operations?

Responsive Resident
Responsive Resident

Managed to find solution using multiple conditions to check different values of columns.

 

This video has helped to find a solution how to recognize whether the item was updated or created as new: https://www.youtube.com/watch?v=yLBohC1Rw00&t=192s&ab_channel=AlirezaAliabadi

View solution in original post

Helpful resources

Announcements
New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (7,228)