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.

All responses (5)

Answers (1)

isaiah1 16 on at

Like (0)

Report

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

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!
isaiah1 16 on at

Like (0)

Report

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

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?
v-bofeng-msft on at

Like (0)

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

Hi @isaiah1 ,

Please try:

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

Best Regards,

Bof
isaiah1 16 on at

Like (0)

Report

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

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"?
Verified answer

v-bofeng-msft on at

Like (1)

Report

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

Hi @isaiah1 ,

I've made a test for your reference:

1\My lists

2\My flow

Best Regards,

Bof