You’re offline. This is a read only version of the page.
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:
Share
Reportid | 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..
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
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?
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.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
All responses (
Answers (
