You’re offline. This is a read only version of the page.
I have a SharePoint list and using Power Automate, I want to populate a column based on the value of another column.
To explain it simply, let's talk about only the two columns involved.
Column A = Issue Category (multiple selection)
ex. Category 1, Category 2, Category 3
Column B = Assigned To (multiple selection based on the values in Column A)
ex. POC 1, POC 2, POC 3
The trigger I'm using is "When an item is created or modified"
So for example, a user created an entry:
Column A = Category 1 and Category 3
This should populate Column B with POC 1 and POC 3.
If the user updates the item and removed Category 3 in Column A, then the flow should also be able to remove POC 3 in Column B.
In the same way, if the user updates the item and added Category 4 in Column A, then the flow should also be able to add POC 4 in Column B.
I appreciate all your help! I don't know how to proceed.
Hi @LOPEZCF ,
If choices in ColumnA are ' Category number' format and choices in ColumnB are 'POC number' format, you can use 'replace' in expression to change 'Category' with 'POC'. Then put the result in ColumnB.
Please try this:
testChoice->ColumnA
testChoice2->ColumnB
The update item action:
Add output of select in ColumnB.
The expression in Select action:
Share
Report
All responses (
Answers (
replace(item()?['Value'],'Category','POC')
Thanks for reading!
Rimmon
#1
WarrenBelz
146,587
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
