title: Update a column based on value of another column
body: <p>I want a Power Automate flow to update a column (Pickable) based on the value of another column (Location). The logic is that if the character after the second period in the Location column is a 3, the Pickable location value should be &quot;No.&quot; Otherwise it should be &quot;Yes.&quot; Here's my set up.</p>
  <ul>
  <li>List Rows (Dataverse table)</li>
  <li>Apply to Each (output from List Rows)
  <ul>
  <li>Update a Row (same table as List Rows / row ID is the standard Dataverse ID column)</li>
  </ul>
  </li>
  </ul>
  <p>This is the expression I <strong>want</strong> to use in the Update a Row action for the Pickable column, but it doesn't work:</p>
  <p><code>if(split(item()?['Location'], '.')[2]='3','No','Yes')</code></p>