title: SharePoint List customized in PowerApps : Automatically change value of dropdown column based on selection in another dropdown
body: <p>I’m new to SharePoint and PowerApps, can you help me on this one on how to resolve this issue?</p>
  <p>I have my SharePoint list customized through PowerApps.</p>
  <p>These are the dropdown columns that were set to automatically change value based on selection of one another.</p>
  <ol>
  <li>BOG Disposition</li>
  <li>Encoder’s Disposition</li>
  </ol>
  <p>The scenario are the following below.</p>
  <ol>
  <li><p>If BOG Disposition is equal to “Return (For Checking)” then the value of Encoder’s Disposition will automatically change to “Awaiting User’s Response” - <em>This scenario is okay and working fine both for SharePoint and PowerApps but the problem is the second scenario.</em></p>
  </li>
  <li><p>Once the value of Encoder’s Disposition was now changed into “User’s Responded”, BOG Disposition must be changed into “Pending”. However, there is an error on formula saying <em>“This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value”</em></p>
  </li>
  </ol>
  <p>I tried resetting the value of BOG Disposition but still not working.</p>