web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Update a SharePoint li...

Power Automate

Answered

Update a SharePoint list column value based on another column value

(0) Share

Report

Report

Posted on by LOPEZCF

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.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:
replace(item()?['Value'],'Category','POC')

Thanks for reading!
Rimmon

Was this reply helpful? Yes No

Join the conversation