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