Unanswered

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

(0) Share

Report

Posted on by Community Power Pla...

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..

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Amanthaper 441 on at

Like (1)

Report

Hi @Anonymous
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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No