Answered

Linking 2 choice columns from different SharePoint Lists so that when one is changed the other automatically changes

(0) Share

Report

Posted on by isaiah1

I have 2 SharePoint Lists: Issue Tracker and Manager Change.

Both lists have a column called "Status" that has the choices Completed, New, In progress, On Hold. How do I link these 2 columns so that when the status is changed in 1 list it automatically updates the status in the other list. Each list has a "Form ID" column that can be used to determine which entry needs to be updated.

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @isaiah1 ,

I've made a test for your reference:

1\My lists

2\My flow

Best Regards,

Bof

Was this reply helpful? Yes No
isaiah1 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply! I create the flow, but in the "Update Item" action when I go to "status value" it will not allow me to put in dynamic content. How do I allow dynamic content into "Status Value"?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @isaiah1 ,

Please try:

triggerOutputs()?['body/Status/Value']

Best Regards,

Bof

Was this reply helpful? Yes No
isaiah1 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! I have the flow running. When the status is changed in the "Manager Change" list will it automatically update in the "Issue Tracker" list also? Or do I need to build another flow?

Was this reply helpful? Yes No
isaiah1 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

This flow only goes 1 way. Meaning when the status is updated in "Manager Change" it updates in the "Issue Tracker", but when the status is updated in the "Issue Tracker" it does not update in "Manager Change". I built a flow like the one above, but with the trigger being when the Issue Tracker is modified. This is giving me an error - "Column 'FormID' does not exist. It may have been deleted by another user.
clientRequestId: 2a92a32c-b512-469c-b13e-7d0c4b3bddab
serviceRequestId: 2a92a32c-b512-469c-b13e-7d0c4b3bddab"

Can you please tell me how I can make the flow so that it updates both ways? (If status is updated in the issue tracker is updates in Manager Change and vice versa)

Thank you!

Was this reply helpful? Yes No